Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
LOOKUP Help
Hi
I have 3 columns of data. (approx 1,000 rows) The 1st column has an identifier number (ie; PN22001-A in cell A1) The 2nd Colum has a colour (ie; Mist Green in cell B1) The 3rd colum has a stock number (ie; 4505-3456 in cell C1) I would like to be able to have a lookup table in the 4th column that when the idendifier number is typed in the next 2 adjacent cells returns the colour and the stock number. Is this possible? Any help would be much appreciated. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |