VLookup

[John]

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?

 

[Bob Phillips]

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.

 

[John]

I found a space

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.