Look Up Range- 2 Values

Hello,

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

image

use it inside Excel application scope

Regards

@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.

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

Regards

@B_H_Akshatha_Pai,

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

Regards,

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.