Vlook up for multiple inputs

Can we use lookup for checking multiple conditions at once. As I find if condition too lengthy in this regards. Any alternate solution is much appreciated.

Hi Sai Deepthi,

can you please explain the condition briefly that you want to use in if condition?