Vlookup to left

Microsoft Excel 2003 (full)
January 21, 2010 at 20:49:10
Specs: Windows XP
Hi Tom,

I have data like this:
A1 B1 C1
A1 Product Item Price
A2 Pen 20 100
A3 Pencil 50 300
A4 Eraser 20 200
A5 Calculator 40 500

I have 4 sheets that contained same data type like above with different contain. I want to get top 5 item from 4 sheets. I already got the top 5 item using LARGE function, but i can't get the price and the product based on that item. I already try using VLOOKUP to get the price, but i get the same price because vlookup always read the first record.

Could u help me tom? i really need ASAP
thanks :)

See More: Vlookup to left

Report •

January 21, 2010 at 21:10:33
Post this in the Office Forum... the link is on the right of this page.

Home Page http://ewen.uuuq.com/

Report •
Related Solutions

Ask Question