| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup
I have 2 columns and wish to retrive the info from the 2nd column. If I type
the name from the 1st column I get #N/A, if I copy directly from the 1st column I get the correct answer, my formula is =VLOOKUP(C2,$A$2:$B$180,2,FALSE) Why can I not get the info when I type it in? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup
Why can I not get the info when I type it in?
Because what you're typing doesn't match what's in the column. There may be unseen whitespace characters in the column and you're probably not typing those in. When you copy from the column you're copying those whitespace characters so there's a match. Look for leading/trailing whitespace characters in A2:A180. -- Biff Microsoft Excel MVP "newkid47" wrote in message ... I have 2 columns and wish to retrive the info from the 2nd column. If I type the name from the 1st column I get #N/A, if I copy directly from the 1st column I get the correct answer, my formula is =VLOOKUP(C2,$A$2:$B$180,2,FALSE) Why can I not get the info when I type it in? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
