Look Up Range- 2 Values

[WS_Chai]

Hello,

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

[B_H_Akshatha_Pai]

use it inside Excel application scope

Regards

[WS_Chai]

@B_H_Akshatha_Pai,

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

[B_H_Akshatha_Pai]

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

Regards

[WS_Chai]

@B_H_Akshatha_Pai,

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

[B_H_Akshatha_Pai]

what exactly are you trying to do here ?

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

Regards,

[postwick (Paul)]

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 “”