vlookup table

[matmich]

i use a vlookup to find the location to items. will vlookup find mor
than 1 location listed in the database for the same item or will i
only return the 1st location that matches the lookup value?

 

[Frank Kabel]

Hi
only the first match is returned

 

[Alan Beban]

You might want to consider the VLookups function in the freely
downloadable file at http://home.pacbell.net/beban

Alan Beban