Include vlookup within if statement

**jpruffle** · 07-14-2009, 05:45 PM

Hi,

How can you return a Vlookup as a true value in an If statement?

For example

=IF(A2>B2,"yes","no")

To something like:

=IF(A2>B2,"=VLOOKUP(AF5,commsafe,5,FALSE)","no")

Pardon my ignorance and thank you for any help.

**Paul** · 07-14-2009, 05:49 PM

You would leave out the "=" sign, for example:

IF(A2>B2,VLOOKUP(AF5,commsafe,5,0),"no")

**jpruffle** · 07-14-2009, 05:52 PM

Once again Paul Thank you.

Re: Include vlookup within if statement