Hi!

Iīm new here and i stumbeled upon a problem.
I need a function that can look for some values for me and i donīt really know if VLOOKUP is the solution or not.
What i want to do is something like this:
=IFERROR(VLOOKUP(MANY DIFFERENT VALUES;'Sheet2'!B100:Z100;2;FALSE);"")
Like
=IFERROR(VLOOKUP(Value1 or Value2 etc.;'Sheet2'!B100:Z100;2;FALSE);"")
So when a calculation in the table in Sheet2 shows any of this values i want the VLOOKUP to work.

Is this even possible?

I hope you understand what im looking for.

Thanks in advance!