VLOOKUP REQUIRES ASCENDING ORDER

Posted by david on December 13, 2001 7:57 AM

I want to refer to invoice # on current row of spreadsheet and pull dollar amount of that invoice from another spreadsheet. However, vlookup function requires data be sorted in ascending order, which I don't want to do.

How can I use Excel to lookup an invoice # on current row and then go to other sheet, find invoice # and return value that is on same row of the other sheet?

Please e-mail response.

Posted by Juan Pablo G. on December 13, 2001 8:02 AM

Vlookup DOESN'T require ascending order. [NT]

=VLOOKUP(ThisSheet!A1,ThatSheet!A1:B100,2,0)

Juan Pablo G.

Posted by IML on December 13, 2001 8:57 AM

Unless the 4th argument is "True" (NT)