Hi,

I am having problem with VLOOKUP that can solve my problem.

I have the following table with the following condition. For example, if A
meet both condition 1 and 2, it should return a result of "AA".

Data Condition 1 Condition 2 Results
A 1 ! AA
B 2 @ BB
C 3 # CC
D 4 $ DD
E 5 % EE

What is the function that I can use in order to lookup the data with the
following inputs so that it can return the correct results based on the above
condition?

Data Input 1 Input 2 Results
A 1 @
A 1 ! ------ expect to give AA
C 6 !
D 4 $ ------ expect to give DD
D 3 $
C 4 #
E 5 % ------ expect to give EE