View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dennis.davis@gmail.com is offline
external usenet poster
 
Posts: 9
Default Vlookup when multiple values can be returned

I have a spreadsheet with data in the following manner

Sheet 1
Col A. Col. B
Tool Number Tool Order #
J123 T008
J598 T258
J123 T568


On Sheet 2 in Column A, cell A2 I have the values I would like to
lookup in Sheet 1 Col A.
I need to return all values in Column B (Tool Order) on Sheet 2.

Anyone have any insight?

Thanks,
Dennis