Using VLOOKUP within an IF statement to return the correct Operator

[Iiaao]

HI

Is it possible to use VLOOKUP to "fetch" the greater than or less than symbol in an IF function.

Effectively =If(A1>B1,"WIN","LOSE") would be something like =If(A1"VLOOKUP(C3,D6:E11,2,FALSE)",B1,"WIN","LOSE")

Thanks in advance

 

[jmacleary]

Hi there. You could use this formula: =IF(AND(E11=">",A1 > B1),"WIN",IF(AND(E11="<",A1 < B1),"WIN","LOSE")) <b1),"win","lose"))<b1),"win","lose"))

It tests E11 directly for the < or > symbol - you could replace that with something else if you prefer.

Regards
John</b1),"win","lose"))<b1),"win","lose"))