Fix VLOOKUP

[@lmajiedmary]

I have been to a vast array of teachers on RUclips on the subject of excel and have found your site to be, by far, the best. Thank you so much for the simplification in your lessons. Now that I have found you, I have come to you for quite a few issues I have come across and you always give me exactly what I need!! You are now my "go to" person!!! Thank you, thank you!!

[@kingpinn13]

that @ saved me. been trying to find a solution for the last 2 days

[@IvanCortinas_ES]

Excellent explanation Chester. It is a symbol that we find when opening files treated before the spilled-array arrived. Thank you!!!

[@Mohammed-wz7en]

Thank you so much! It was hard to find a video that explained the #spill error without requiring us to fill the array of data below the cell. However, you mentioned that we could use the @ symbol to resolve the error, which worked for me. Big thanks.

[@ScottRuss-g4u]

Thanks for this quick, clear explanation! This was really helpful.

[@jramaswamy]

Excellent lesson. Simple and straightforward. Thank you.

[@mnrqt]

Thank you, the last tip to select the lookup value as a single cell solved the issue for me.

[@hasanghassan4308]

You have fixed my issue, thanks Chester

[@AB-qb6pt]

chester you are the man !

[@myintmoe-b8e]

It's great & useful answer for me. Thank you very much.

[@manojkumarm6609]

You Saved my time sir,thank tou❤

[@wayneedmondson1065]

Good tips! Thanks Chester. Thumbs up!!

[@Patreon-rz9ed]

Thank u so much .
It’s working 😊😊😊😊

[@patrickschardt7724]

It’s a good thing Microsoft only has this error if you reference an entire column (and assuming whole rows). Otherwise, we would get this error all the time since a table could become the whole column.
Good tips to get around it.

[@samadritashaw3352]

Thanks a lot! This helped me

[@bh844]

Miss the old Excel never had the Spill error

[@itxneh]

IN FIRST I'M NOT WATCH THIS VIDEO COMPLETELY I'M GOING ON ANOTHER VIDEO BUT I DON'T GAVE ANY SOLUTION AFTER THAT IS IN HALF ON MY SCREEN I'M WATCH COMPLETELY & SOLUTION IS VERY SUCCESSFULL

[@IndianaBlu]

Thank you!

[@ahmedmoatsem8355]

Many Thanks

[@dhirajsinghchauhan4413]

Thanks a lot Chester

[@vipinpadiyan99]

Excellent usefull

[@toshtosh2000]

Thank you so much!!!!!!

[@sushilgaikwad4338]

Thanks Chester

[@chandrashaker309]

Thank you boss

[@AB-qb6pt]

chester if we would like to make a statue, the cement wont be enough !

[@dk-jq2iz]

Thanks Sir

[@malvinmohammad8395]

Thanks!

[@riderthakur]

Thanks a lot

[@arshiyaaashi1938]

Thanks alot

[@viveksinghgulia8739]

nice video

[@LalaLa-tn8do]

Tq