Help with Vlookup

[dario88m]

Hi all!
I'm new to the forum so, apologies for any mistakes with my post in advance

I have several worbooks that at a certain point started not showing values for vlookup formulas. To be more specific.. for example everything works as it should until row 50 and then from 51 I get #NA. I checked practically everything and i can't find a single reason why this is happening

I can give more details if necessary.

As anyone experienced this issue and knows what is causing this?

Example attached in the picture

Thanks

 

[etaf]

what formula are you using
have you fixed the range with $
A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC , then put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

 

[dario88m]

Hi, thank you for your reply.
Formula example : =VLOOKUP($A$2,Sheet1!$A$3:$N$99999,2,FALSE)
I downloaded XL2BB but I'm not sure how to make it work since I have multiple ranges in several sheets

It's probably easier if I make a copy of the workbook removing sensitive data and then share it.

 

[etaf]

a2 is fixed , so as you copy down its always referring to A2
$A$2

so in theory - you should always get the same result
from column B on sheet1

It's probably easier if I make a copy of the workbook removing sensitive data and then share it.

ok

 

[dario88m]

a2 is fixed , so as you copy down its always referring to A2
$A$2

so in theory - you should always get the same result
from column B on sheet1


ok

a2 is fixed as I'm not copy down. the sheet works as a form, you type the value in a2 to get all data associated and when you're done you run a macro but ofc now the macro is pasting N/A in all other worbooks and sheets

 

[etaf]

ok, sorry, I'm not going to be able to help as its a macro , i do not provide solutions to macros on forum here - was not clear from 1st post.

 

[dario88m]

ok, sorry, I'm not going to be able to help as its a macro , i do not provide solutions to macros on forum here - was not clear from 1st post.

I guess it's a misunderstanding here. The macro is only the final step, the issue is only the vlookup.