Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup table error
Whyn do I get NA error when I type the following formula.
=VLOOKUP(B5,SS!$A$2:$C$170,2) SS is the worksheet A2 has last name C170 has personal ID # Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup table error
Likely cause:
What's in B5 isn't found in A2:A170 OR A2:A170 is not sorted. "da" wrote in message ... Whyn do I get NA error when I type the following formula. =VLOOKUP(B5,SS!$A$2:$C$170,2) SS is the worksheet A2 has last name C170 has personal ID # Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup table error
Try instead: =VLOOKUP(B5,SS!$A$2:$C$170,2,FALSE) to find exact match in an unsorted range... if you still get the #N/A error, then Vlookup has not found an exact match to B5 in SS!A2:A170... If you think there is a match, check for spelling, extra spaces, format (number,text), etc... It has to be exact. -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109441 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup table error
If the data in Column A is sorted use
=VLOOKUP(B5,SS!$A$2:$C$170,2,FALSE) If this columns is not sorted then try =INDEX(SS!$A$2:$C$170,MATCH(B5,SS!$A$2:$A$170,0),2 ) If this post helps click Yes --------------- Jacob Skaria "da" wrote: Whyn do I get NA error when I type the following formula. =VLOOKUP(B5,SS!$A$2:$C$170,2) SS is the worksheet A2 has last name C170 has personal ID # Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup table error
Jacob Skaria;391947 Wrote: If the data in Column A is sorted use =VLOOKUP(B5,SS!$A$2:$C$170,2,FALSE) If this columns is not sorted then try =INDEX(SS!$A$2:$C$170,MATCH(B5,SS!$A$2:$A$170,0),2 ) If this post helps click Yes --------------- Jacob Skaria "da" wrote: Whyn do I get NA error when I type the following formula. =VLOOKUP(B5,SS!$A$2:$C$170,2) SS is the worksheet A2 has last name C170 has personal ID # Thanks Why do you need FALSE in the Vlookup if the column is sorted? -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109441 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Error #N/A | Excel Discussion (Misc queries) | |||
VBA Vlookup Error | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |