Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP ISSUE - Take II
Hi All,
I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the function I do a find on a value from the table array into the lookup worksheet. It finds the value so the function should work. Having verified the val exists the function automatically updates and inserts the value from the table array. When I then copy & past the same row the output is "#NA". Again, when I use the find feature it updates the function. The calculation is as follows: =VLOOKUP(C25,Data!$A$2:$B$317,2,FALSE) Can anyone assist with identifying the cause? Thanks in advance, H |
#2
|
|||
|
|||
Hi,check whether your table array in the formular is okay
-----Original Message----- Hi All, I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the function I do a find on a value from the table array into the lookup worksheet. It finds the value so the function should work. Having verified the val exists the function automatically updates and inserts the value from the table array. When I then copy & past the same row the output is "#NA". Again, when I use the find feature it updates the function. The calculation is as follows: =VLOOKUP(C25,Data!$A$2:$B$317,2,FALSE) Can anyone assist with identifying the cause? Thanks in advance, H . |
#3
|
|||
|
|||
Hello,
Thanks for replying. I reviewed the formula and it seems fine. I'm a little lost on this one. Cheers - H "Magoiya" wrote: Hi,check whether your table array in the formular is okay -----Original Message----- Hi All, I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the function I do a find on a value from the table array into the lookup worksheet. It finds the value so the function should work. Having verified the val exists the function automatically updates and inserts the value from the table array. When I then copy & past the same row the output is "#NA". Again, when I use the find feature it updates the function. The calculation is as follows: =VLOOKUP(C25,Data!$A$2:$B$317,2,FALSE) Can anyone assist with identifying the cause? Thanks in advance, H . |
#4
|
|||
|
|||
Hi
if you'ld like to email the workbook directly to me (julied_ng at hcts dot net dot au) i'll be happy to take a look Cheers JulieD "Hardip" wrote in message ... Hello, Thanks for replying. I reviewed the formula and it seems fine. I'm a little lost on this one. Cheers - H "Magoiya" wrote: Hi,check whether your table array in the formular is okay -----Original Message----- Hi All, I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the function I do a find on a value from the table array into the lookup worksheet. It finds the value so the function should work. Having verified the val exists the function automatically updates and inserts the value from the table array. When I then copy & past the same row the output is "#NA". Again, when I use the find feature it updates the function. The calculation is as follows: =VLOOKUP(C25,Data!$A$2:$B$317,2,FALSE) Can anyone assist with identifying the cause? Thanks in advance, H . |
#5
|
|||
|
|||
Hi Julie,
Thanks for the kind offer. I've sorted the problem which was to do with formatting. In short my lookup array was from an MS Excel spreadsheet and the main table from a txt file. I concatanated the fields and it worked - highly longwinded though. All the best, H "JulieD" wrote: Hi if you'ld like to email the workbook directly to me (julied_ng at hcts dot net dot au) i'll be happy to take a look Cheers JulieD "Hardip" wrote in message ... Hello, Thanks for replying. I reviewed the formula and it seems fine. I'm a little lost on this one. Cheers - H "Magoiya" wrote: Hi,check whether your table array in the formular is okay -----Original Message----- Hi All, I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the function I do a find on a value from the table array into the lookup worksheet. It finds the value so the function should work. Having verified the val exists the function automatically updates and inserts the value from the table array. When I then copy & past the same row the output is "#NA". Again, when I use the find feature it updates the function. The calculation is as follows: =VLOOKUP(C25,Data!$A$2:$B$317,2,FALSE) Can anyone assist with identifying the cause? Thanks in advance, H . |
#6
|
|||
|
|||
glad it's solved
"Hardip" wrote in message ... Hi Julie, Thanks for the kind offer. I've sorted the problem which was to do with formatting. In short my lookup array was from an MS Excel spreadsheet and the main table from a txt file. I concatanated the fields and it worked - highly longwinded though. All the best, H "JulieD" wrote: Hi if you'ld like to email the workbook directly to me (julied_ng at hcts dot net dot au) i'll be happy to take a look Cheers JulieD "Hardip" wrote in message ... Hello, Thanks for replying. I reviewed the formula and it seems fine. I'm a little lost on this one. Cheers - H "Magoiya" wrote: Hi,check whether your table array in the formular is okay -----Original Message----- Hi All, I am using the function and the output is "#NA" - there's obviously something wrong. I've checked the field are the same format etc. To test the function I do a find on a value from the table array into the lookup worksheet. It finds the value so the function should work. Having verified the val exists the function automatically updates and inserts the value from the table array. When I then copy & past the same row the output is "#NA". Again, when I use the find feature it updates the function. The calculation is as follows: =VLOOKUP(C25,Data!$A$2:$B$317,2,FALSE) Can anyone assist with identifying the cause? Thanks in advance, H . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP ISSUE | 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 | |||
Vlookup datatype(?) issue | Excel Worksheet Functions |