VLOOKUP or IF(ISBLANK) formula?

dilleyz

I am trying to find a formula that will pull the information from the Building and reception level columns onto another sheet based on if the Assigned Receptionist column is blank. I'm not sure if this would be a VLOOKUP or an IF formula. Is this sort of function possible? Thanks for the assistance!

KPH

You can use both!

You can start with an IF function, in the logic use ISBLANK, if the logic returns true do one thing, if false do another. The "thing" could be the VLOOKUP (or INDEX MATCH).

But if the only need for the check on blank is so that nothing is returned if there isn't a match in the lookup, you could just use an IFERROR around the lookup.

Take a look at:

https://www.smartsheet.com/content-center/best-practices/tips-tricks/3-formulas-look-up-data-smartsheet