VLOOKUP ISSUE - Take II

[Hardip]

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

 

[Magoiya]

Hi,check whether your table array in the formular is okay

 

[Hardip]

Hello,

Thanks for replying. I reviewed the formula and it seems fine. I'm a
little lost on this one.

Cheers - H

 

[JulieD]

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]

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]

glad it's solved

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