sobeitjedi
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 235
- Office Version
- 365
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!
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:
