Proper Syntax for IF and VLOOKUP

Detrie Zacharias

I am trying to create a formula that will run VLOOKUP if a cell is blank

This doesn't error but it leaves the formula field blank

=IF((USERR3 <> ""), (IF((VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false)) = 0, "No", "")))

Paul Newcome

=IF(USERR3 <> "", IF(VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false) = 0, "No", ""))

Give that a try. What exactly is the VLOOKUP pulling?

Paul Newcome

=IF(USERR3 <> "", IF(VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false) = 0, "No", ""))

Give that a try. What exactly is the VLOOKUP pulling?

Detrie Zacharias

That worked Paul... My nemesis the dreaded parenthesis

It is hitting a Salesforce user sheet to let me know if the user is active or not

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as the "Accepted Answer" so that others know a solution has been found.

APalani

HI Paul,

I created a sheet which needs to vlookup to another sheet, but there are duplicate listing. I have created a column "Module" , which creates the unique rows. But how will I get to verify using the Module.

=IF(Module@row = "Option", VLOOKUP([Part Number]@row, {Bill of Materials - eBOM - 1 Range 22}, 1, false), 0)

Thanks!

Paul Newcome

@APalani Are you able to provide some screenshots for reference?

APalani

Hi Paul,

When there is no m during comparison, it is throwing #NO Match, but i want 0 in that place.

Is it possible to change?

Paul Newcome

You would need to wrap it in an IFERROR like so...

=IFERROR(IF(Module@row = "Option", VLOOKUP([Part Number]@row, {Bill of Materials - eBOM - 1 Range 22}, 1, false), 0), 0)

APalani

HI Paul,

I am trying to verify the PN across the module with another sheet. I tried this formula, it keeps throwing error. Both Module and PN are in other sheet as well.