What is the value the lookup returns?
As in, is it a number or text?
A | B | C |
1 | Peter | 22.99 |
2 | John | 10 |
3 | Craig | 20 |
4 | mark | 19.99 |
5 | Steven | 13.55 |
6 | Ralph | 23.44 |
7 | Roger | 22.22 |
Just my way.....
SHEET 1
A B C 1 Peter 22.99 2 John 10 3 Craig 20 4 mark 19.99 5 Steven 13.55 6 Ralph 23.44 7 Roger 22.22
<tbody>
</tbody>
First way...
=IF(VLOOKUP(A1,Sheet1!B1:C7,2,FALSE)>15.99,"TRUE","FALSE")
Second Way
=IFERROR(IF(MATCH(A9,Sheet1!B:B,0),"TRUE"),"FALSE")