Any help greatly appreciated. I have a simple formula that looks at the last digit of a hosts port name and then does a VLookup against a table in order to balance the load. My problem is that the formula only works when the table ends with a letter, and not when ending in a number.
REFERANCE CELL "B8" = 20:00:00:25:b5:40:a0:F0
VLookup range in CELL A19-B34 =
0 A
1 B
2 A
3 B
4 A
5 B
6 A
7 B
8 A
9 B
A A
B B
C A
D B
E A
F B
FORMULA = =VLOOKUP(RIGHT(B8,1),A19:B34,2)
If my lookup ends with a letter, everything works great, when it ends with a number I get a "#N/A" result. Any and all help greatly appreciated.
Bookmarks