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 |
LOOKUP Help
One way ..
Assuming inputs for the identifier number will be made in a 2-part form, eg in E1: PN22001, in F1: A Then we could place in D1: =IF(OR(E1="",F1=""),"",INDEX(B:B,MATCH(E1&"-"&F1,A:A,0))&", "&INDEX(C:C,MATCH(E1&"-"&F1,A:A,0))) D1 will return the result from cols B & C as: Mist Green, 4505-3456 D1 can be copied down to return correspondingly for other pairs of inputs in E2:F2, E3:F3, etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John Calder" wrote: 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 |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com