Look up

[Compqueen]

Is there a way to use a VLookup where your look up table is not sorted in
alpha order?

 

[Jim Cone]

Use False or 0 for the fourth argument.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Compqueen"
wrote in message
Is there a way to use a VLookup where your look up table is not sorted in
alpha order?

 

[Dave]

Hi,
Yes. If you use the 4th argument and set it to FALSE.
=VLOOKUP(LookupValue,LookupTable,ColumnToReturn,FALSE)
By using the FALSE argument, VLOOKUP looks for an exact match only, and
doesn't need the table to be sorted alphabetically.
However, if VLOOKUP doesn't find the LookupValue you give it, it returns a
#N/A error, which you can trap for if you want.
=IF(ISNA(VLOOKUP(LookupValue,LookupTable,ColumnToReturn,FALSE),"Lookup Value
Not Found",VLOOKUP(LookupValue,LookupTable,ColumnToReturn,FALSE)

Regards - Dave.