Microsoft Excel 2003 (full)

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 500I 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 :)

Post this in the Office Forum... the link is on the right of this page. Home Page http://ewen.uuuq.com/

Ask Your Question

Weekly Poll