Advanced use of IF

B

Backdoor Cover

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 o
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 on
week account ID 239 might not buy anything from us so I won't need hi
notes.

I have wasted a lot of time doing this manually so I would be thrille
if someone could help.

Thanks!
Luk
 
N

Niek Otten

Hi Luke,

Look in HELP for the VLOOKUP function.
Pay attention to the description of the 4th argument of that function.

"Backdoor Cover"
 
B

BenjieLop

Backdoor said:
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
Click to expand...

Will this formula help you?

=if(countif(Notes!$A$1:$A100,A7)>0,vlookup(A7,Notes!$A$1:$B$100,2,0),"")

Regards.
 
A

Arvi Laanemets

Hi

=IF(ISERROR(VLOOKUP(A7,Notes!$A$1:$B$1000,2,0)),"",VLOOKUP(A7,Notes!$A$1:$B$
1000,2,0))


Arvi Laanemets


"Backdoor Cover"
 
Top