Lookup query

sobeitjedi

Board Regular
Joined
Mar 13, 2006
Messages
187
Hi.

In Sheet0 I have columns A to O populated with travel data.
E contains email address
I contains departure date
L contains country

B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value in the sheet TA and returns a yes or no value.

This all works great.

My question is, I now want to add into p2 in Sheet0, whatever is the value in column O in TA, for the matched row specified from the formula above.

Does that make sense? Please help!
 
Last edited:

sobeitjedi

Board Regular
Joined
Mar 13, 2006
Messages
187
Pretty sure I need a vlookup somewhere in the formula, but can't work out how???
 

Forum statistics

Threads
1,082,504
Messages
5,365,956
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top