Backdoor Cover Wrote:
I am trying to come up with a formula that does this.
If A7 on worksheet '05-29' is equal to any of the cells in column A on
worksheet 'notes' then give me the data in Column B on that same row.
I assumed a basic IF formual like this =IF(A7=Notes!A1,Notes!B1,"")
would work but it relies on the cells being in order everytime. In one
week account ID 239 might not buy anything from us so I won't need his
notes.
I have wasted a lot of time doing this manually so I would be thrilled
if someone could help.
Thanks!
Luke
Will this formula help you?
=if(countif(Notes!$A$1:$A100,A7)0,vlookup(A7,Note s!$A$1:$B$100,2,0),"")
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=376078