IFERROR(VLOOKUP help

ealexis ✭✭

Hello,

Can someone please help me if a vlookup formula

This is what I have,

=IFERROR(VLOOKUP([Student ID]@row, {IDsheet}, 1, false), "Not Found")

But I also want to include another category that must be check before the answer comes back from the same IDsheet

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Help please
I have a column that keeps returning errors….causing quite a bit of confusion and frustration. The first threat formula is working as intended. First milestone threat formula: =IF(AND([Percent complete]@row <> 0.1, TODAY() > [Currentmilestone date]@row +14),"Red", IF(AND([Percent complete]@row < 0.1, TODAY() >…
How do I summarize text data from multiple cells into one cell only if criteria is met in each cell?
I am sending a form out to associates in which I ask them to rate their familiarity with multiple subjects. The 3 available choices for them to choose from are: Very Familiar, Somewhat Familiar and Not Familiar. I would like to summarize their responses from multiples cells (Sales Orders, Invoicing, Stock Status, Purchase…
If Contains lookup to another sheet result is empty show value from other cell in row?
I have the following formula in a cell that until now was successfully looking up a date in another sheet and when the match of "OSHA Inspections" was true in that other sheet it would grab the most recent date for the shipto id. What I'm trying to do is modify the formula so that when the date field is blank in the…