fry
Active Member
- Joined
- Apr 25, 2007
- Messages
- 411
Hi All
I'm using the following
If I enter "313" in P5 I get the correct value in the cell above but if I enter RIGHT(F5,3) in P5, which is the same I get #N/A??????????
Help...
P.S. F5 = "ABC/123/313 therefore RIGHT(F5,3) = 313 ????????
I'm using the following
Code:
VLOOKUP(P5,Data!$E$1:Data!$F$89,2,FALSE)
If I enter "313" in P5 I get the correct value in the cell above but if I enter RIGHT(F5,3) in P5, which is the same I get #N/A??????????
Help...
P.S. F5 = "ABC/123/313 therefore RIGHT(F5,3) = 313 ????????