Lookup I think

[DP7]

I am not sure what function to use to get this done. I have a number in Colum
A that may or may not have up to 5 corresponding values in Colum B. I have a
list of Colum A numbers that I need to pull the Colum B values. There are
over 2000 lines in the table & I have 236 Colum A numbers to look up. Any
suggestions about how to getting this done would be greatly appreciated.

 

[CLR]

Sounds like a job for a Pivot Table.......

Vaya con Dios,
Chuck, CABGx3