VLOOKUP problem #NA error

[I2omani]

This is a weird one I am trying to wrap my head around.

I created a workbook with three sheets, I do a vlookup formula that looks like this:=VLOOKUP(D3,Sheet3!A:D,2,FALSE)

so basically, find the value of D3 and look for the exact match in sheet 3 (column range a-d) then report back the value found in the second column.

I get an #NA error with this. Funny thing is that if I go to sheet 3, find the correct value and "re-type" it in, it will now pull the information I want.

I've tried some basic formatting changes that dont fix the issue and the only thing that seems to work is retyping the values into sheet 3.

any ideas?

I've got about 1500 rows I'd have to retype so the idea doesnt excite me.

 

[Kamran84]

Dear!

copy all the data of the sheet 3 and past it as special value. than your vlook will took all the value.

hope this will solve your problem.

Kamran

This is a weird one I am trying to wrap my head around.

I created a workbook with three sheets, I do a vlookup formula that looks like this:=VLOOKUP(D3,Sheet3!A:D,2,FALSE)

so basically, find the value of D3 and look for the exact match in sheet 3 (column range a-d) then report back the value found in the second column.

I get an #NA error with this. Funny thing is that if I go to sheet 3, find the correct value and "re-type" it in, it will now pull the information I want.

I've tried some basic formatting changes that dont fix the issue and the only thing that seems to work is retyping the values into sheet 3.

any ideas?

I've got about 1500 rows I'd have to retype so the idea doesnt excite me.