ExcelBanter - Lookup I think

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lookup I think (https://www.excelbanter.com/excel-worksheet-functions/175308-lookup-i-think.html)

DP7

Lookup I think

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

Lookup I think

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

Vaya con Dios,
Chuck, CABGx3

"DP7" wrote:

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.

All times are GMT +1. The time now is 07:14 PM.