Google Sheets - The #NA! Error and How to Fix It

Показать описание

If you get the #NA! error when you're using a formula in Google Sheets, this video will help you to understand what it is and how to fix it.

🕒 Timestamps
0:00 Intro
0:45 VLOOKUP Demo
2:04 Hidden character (space)
3:14 Get access to the Sheet
3:44 TRIM Function
4:29 Incorrect range
6:34 Error handling
9:27 MATCH Function

Learn more from Prolific Oaktree:

#googlesheets #NA #error

Рекомендации по теме

Комментарии

I've been staring at various REF and N/A errors all morning, but the 'trim' code fixed it - thank you so much!

steventunney

I'm about to go crazy with the #NA error. TRIM function fixed everything, thank you for that, thanks!

aygunaytekin

Thanks a lot, By you saying don't leave anything blank solved a lot of problems, it just means I cant leave lines black to add more in the future and will have to add them later as i need them

philiphorton

The white space gave me a hint on solving this for my sheet, I was having the issue where the number format was automatic on one sheet, and plain text on the other, they both had to match up in order for vlookup to find the key value.

FinsterDexter

Thanks, that was super helpful, needed to know how to make N/As blank as they were breaking my SUM formula lol

Nevir

Thanks for your help that work well. Do you know if its possible to replace error in data validation list by blank. Because I tried to find solution but not yet find it.

tanguypineau

Any idea what's causing the N/A in this case? Function is =LOOKUP(C2, ChkBal, ChkDates). The value in C2 is populated from the named range ChkBal, but the lookup function reports the value isn't found.

nrdogg

How to deal with missing zeros in some numbers when entering data from a website into Google sheet?

kosoe

I try to import data from a web page into google sheets with the importxml function and sometimes it gives me a normal value in the cell and other times (without changing anything) it gives me #N/A. What can I do? Thanks

dimitrioschantzis

So, I'm trying to create a table where, if I select something from a dropdown menu, it auto-populates values in the corresponding cells below the drop down menu. However, every time I put in the vlookup formula and enter all the values, it keeps giving me the #N/A error. I've tried everything in your video, but it keeps giving me the "Did not find value in VLOOKUP evaluation". I've tried searching online for suggestions on how to fix it, but it still keeps giving me the same error. I'm at a loss as to what to do. Is there anything you can suggest to help fix it?

PDohm