VLookup
 

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?

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?

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?