You can perhaps concatenate columns A and B on first sheet, and lookup in
that range of cells. Much easier.

Alternatively, if the combinations are unique, use a DGET function.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"SMOKN_ENG_MOM" wrote:

I have tried all these index / v look up solutions posted.
First sheet contains data base.....

A B D
1 1 A Happys bar and grill
2 1 B SOnny's bar and grill
3 2 A Macks sweat shop

On the second sheet, i want to enter a formula where i can look up
(second sheet Q5 value in first sheet column A) then (Second sheet Q6 Value
in first sheet column B) and
if both criteria match
return value into second sheet from first sheet column D