View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SMOKN_ENG_MOM SMOKN_ENG_MOM is offline
external usenet poster
 
Posts: 1
Default Two colums match return text from another

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