Hi all,

Can you help?

I have the following data on one worksheet called lamps:

A B C D
1 ME4a 1 10 140w Cosmo
2 ME4b 1 8 140w Cosmo
3 S4 1 7 60w Cosmo
4 S5 1 6 55w PLL
5 S6 1 5 55w PLL
6 S5 1 6 60 Cosmo
7 S7 1 5 36w PLL
8 ME3b 2a 10 140w Cosmo
9 ME3c 2a 8 140w Cosmo
10 ME4a 2a 8 60w Cosmo
11 S4 2a 7 60w Cosmo
12 S5 2a 6 55w PLL
13 S5 2a 5 36w PLL
14 S3 2a 6 60w Cosmo
15 S7 2a 5 36w PLL

On another sheet I have the following entry:

A B C D
1 2A 7 S4

In cell D1 I wnat a function that will look for the 3 entries in column A -
C and return the value from column D on the lamps sheet. So the example
above should return 60w Cosmo.

Any help greatly appreciated.

Regards

Andy