G
Guest
Greetings folks,
My formula in P7 is:
=VLOOKUP(O7,$Q$7:$S$21,3)
The answer in P7 appears to be wrong because 20140 is not found in my range.
But the answer in P8 appears to be correct since 20148 is in my range and
the 3rd column in the range (cell S21) says yes.
O P Q R S
7 20140 Yes 4990 WSJO No
8 20148 Yes 5001 WSJO No
9 20576 Yes 5107 WSJO Yes
10 20732 Yes 5144 WSJO No
11 20909 Yes 5350 WSJO No
12 21277 No 5468 WSJO No
13 21295 Yes 5479 WSJO No
14 21361 Yes 5488 WSJO Yes
15 21478 Yes 5745 WSJO No
16 21539 Yes 5821 WSJO Yes
17 21596 Yes 20000 WSJO No
18 21657 No 20111 WSJO Yes
19 21797 Yes 20114 WSJO Yes
20 21883 Yes 20128 WSJO Yes
21 22024 Yes 20148 WSJO Yes
Can anyone tell me what's wrong here?
Thanks a lot!
My formula in P7 is:
=VLOOKUP(O7,$Q$7:$S$21,3)
The answer in P7 appears to be wrong because 20140 is not found in my range.
But the answer in P8 appears to be correct since 20148 is in my range and
the 3rd column in the range (cell S21) says yes.
O P Q R S
7 20140 Yes 4990 WSJO No
8 20148 Yes 5001 WSJO No
9 20576 Yes 5107 WSJO Yes
10 20732 Yes 5144 WSJO No
11 20909 Yes 5350 WSJO No
12 21277 No 5468 WSJO No
13 21295 Yes 5479 WSJO No
14 21361 Yes 5488 WSJO Yes
15 21478 Yes 5745 WSJO No
16 21539 Yes 5821 WSJO Yes
17 21596 Yes 20000 WSJO No
18 21657 No 20111 WSJO Yes
19 21797 Yes 20114 WSJO Yes
20 21883 Yes 20128 WSJO Yes
21 22024 Yes 20148 WSJO Yes
Can anyone tell me what's wrong here?
Thanks a lot!