IFERROR(VLOOKUP help

ealexis

ealexis ✭✭

08/05/24 in Formulas and Functions

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

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

"Boolean Expected" Error
Hello All, I spent a few hours building an equation (I am not an expert) within a sheet that reads another main sheet. =IFERROR(INDEX(COLLECT({GenFertCalc}, {Client Name}, [Client Name]@row, {Tones}, "Granular Fertilizer (Tone)"), 1), 0) The error message "Boolean Expected" occurs in the correct cells, but instead of…
Trying to create a summary of data from another sheet
Hello All, I have a main sheet, and I want another sheet to read it's data and when conditions are met, click a box. I had wanted it to read a specific date range, but that made it too specific to a year and would have to be changed the following year. The formula below, won't work; ideally I would want a range of months…
HELP!! Needing to subtract just one from this formula
I have this formula for a total count! I just need to subtract 1 from the formula This is what I have and it is showing Unparseable ="2021-2022 Total Contracts: " + COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2022, 12, 31)))-1)