countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 758
Hello friends,
I tried using the Vlook function by looking for 52 or 72 or 66. The arrays are Col A & B.
I understand why it is not working col A does not have an excat match, is there anyway around it to make it work?
COL A COL B
52 0 to 28 1
72 29 to 33 2
66 34 to 37 3
38 to 42 4
43 to 50 5
51 to 58 6
59 to 63 7
64 to 68 8
69 to 95 9
96 10
Thank you,
Nawaf
I tried using the Vlook function by looking for 52 or 72 or 66. The arrays are Col A & B.
I understand why it is not working col A does not have an excat match, is there anyway around it to make it work?
COL A COL B
52 0 to 28 1
72 29 to 33 2
66 34 to 37 3
38 to 42 4
43 to 50 5
51 to 58 6
59 to 63 7
64 to 68 8
69 to 95 9
96 10
Thank you,
Nawaf