Hi, I require a formula that will answer the following problem.

I have cells A1:D100 full of data and these are my reference cells.

I also have cells F1:H50 full of data.

What I require is a lookup formula that will lookup cells F1:H1, F2:H2 etc
compared with cells A1:C100 and if all of the 3 cells are matched then return
the corresponding value from column D.

Thanks