this worked for the NA issue i was seeing. but for some reason i also get a displaying 0 (zero).
Ex. using vlookup to take data from sheet1 and copy to sheet 2. when there is no data in a cell on sheet 1, sheet 2 displays a 0 (zero). there were cells that displayed NA but the isna function solved that problem.
I just solved it. As i copied the function cell i also accidentally copied the '=' sign from the vlookup function so that when i pasted it back in i had a funtion with three '=' signs in the function itself. Simply removed the two additional (and unnecessary) '=' signs to only leave one (at the start of the function) and hay presto. Works like a charm. Thanks for the tutorial. Defo thumbs up! PROBLEM SOLVED! ExcelisHell Rocks!
I followed exactly what you very elequently demonstrated but came up with an error. How come? I checked the code again and again and still no luck. Please help.
imagine you used vlookup to find the information you wanted : like this vid. Could I amend the data i have found so that it changes in the main table.
Example, imagine you wanted to quickly bring up someones email address to change it. You would use vlookup to find it, but how would you change it? Many thanks
Great job bro..
alirazaagha1 3 weeks ago
thanks
palletireddy 3 months ago
Good man. Thanks.
69sico96 4 months ago
Very good. Thank you.
lundgren4711 7 months ago
this worked for the NA issue i was seeing. but for some reason i also get a displaying 0 (zero).
Ex. using vlookup to take data from sheet1 and copy to sheet 2. when there is no data in a cell on sheet 1, sheet 2 displays a 0 (zero). there were cells that displayed NA but the isna function solved that problem.
please help!
eramic23 8 months ago
I just solved it. As i copied the function cell i also accidentally copied the '=' sign from the vlookup function so that when i pasted it back in i had a funtion with three '=' signs in the function itself. Simply removed the two additional (and unnecessary) '=' signs to only leave one (at the start of the function) and hay presto. Works like a charm. Thanks for the tutorial. Defo thumbs up! PROBLEM SOLVED! ExcelisHell Rocks!
MrFriskyWhiskey 11 months ago
I followed exactly what you very elequently demonstrated but came up with an error. How come? I checked the code again and again and still no luck. Please help.
MrFriskyWhiskey 11 months ago
This Rocks!
SheetMonk 1 year ago
This has been flagged as spam show
very good trick,i tryed very hard to find this.And this was exactly what i was looking for.Thank you,uploader! ;)
paulmetalmann 1 year ago
very good trick,i tryed very hard to find this.And this was exactly what i was looking for.Thanck you,uploader! ;)
paulmetalmann 1 year ago
sorry for writing on each vid but
imagine you used vlookup to find the information you wanted : like this vid. Could I amend the data i have found so that it changes in the main table.
Example, imagine you wanted to quickly bring up someones email address to change it. You would use vlookup to find it, but how would you change it? Many thanks
TheDarkemotion21 1 year ago
This is GREAT!!! Thanks
trkurtz 1 year ago