vlookup help

  • Thread starter Thread starter Keyur
  • Start date Start date
K

Keyur

hi!

i have a master inventory list (around 6000+) which has
parts at more than 1 location.

i made another list with some of the parts from the master
list and i m using vlookup to get the locations. but it
gives only the first one it finds in the list. is there a
way i can get all the locations for 1 part?

thanks for all the help.
 
Thanks for the reference, but i didnt quite get how to use
it. a brief explanation will be greatly appreciated.

thanks again
 
One way is to download the file from the site and store it as an Excel
add-in. Then in your workbook, in the VBE editor, check the file to add
it to your library. Then the functions will be available somewhat like
built-in functions.

Alan Beban
 
Back
Top