Look Up Range- 2 Values


May I know what should i write here if i would like to search for value 2021 or FY21 or both?


use it inside Excel application scope



Thanks for your reply, may i know what should i put here?
I would like to search for 2021 or FY21 or both.

It is a string value . you can not put boolean operations like “or” “and” for this
Use Seperate vlookups



I am trying to create a new variable, do you know what this error is?

what exactly are you trying to do here ?

String.empty will give you " " . Kindly elaborate your requirement


It means what the error message says - you are trying to assign an object value to a string variable. If you just want to make OutdateFY21 an empty string, then use “”

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.