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