| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
