Formula not right - help needed

[brendanolear]

Have created formula as below:

=if(F5=Sheet1!$A$2:$A$200,vlookup(G5,Sheet3!$B$4:$C$50,2,false),0)

not returning anything though there is data there that meets criteria.

What am I missing?

 

[barry houdini]

You're comparing F5 to a range, do you want the VLOOKUP triggered if F5 is anywhere in that range? If so try

=IF(COUNTIF(Sheet1!$A$2:$A$200,F5),VLOOKUP(G5,Sheet3!$B$4:$C$50,2,FALSE),0)

 

[brendanolear]

thank you Barry

 

[lenze]

Hi: I'm not sure what you want. Do you mean if F5 is in $A2:$A$200 then VLOOKUP G5?
F5=Sheet1!$A$2:$A$200 is not valid.

lenze
Edit: See Barry's post above