I found a space :(
"Bob Phillips" wrote:
What it probably means is that it doesn't find a match. Check that your text
in B2 doesn't have any superfluous leading or trailing spaces.
--
HTH
Bob Phillips
"John" wrote in message
...
I am doing a simple vlookup on the following data...
FF Target fdtr
FF Effective fedl
Prime prime
1-week LIBOR us0001w
1-month LIBOR us0001m
3-month LIBOR us0003m
3-month T-Bill gb3
6-month T-Bill gb6
1-yr CMT h15t1y
2-yr CMT h15t2y
1-week AG DN agdn007y
1-month AG DN agdn030y
3-month AG DN agdn090y
1-week CP dipa007y
1-month CP dipa030y
3-month CP dipa090y
my formula returns #N/A... why?
=VLOOKUP($B$2,$G$2:$H$17,2, FALSE) where B2 equals FF Target (or any
other
value that is based off of another equation). Does it matter that B2 is
based off of an equation?
|