Fix VLOOKUP

[@lmajiedmary]

I have been to a vast array of teachers on TH-cam 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.

[@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.

[@ScottRuss-g4u]

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

[@AB-qb6pt]

chester you are the man !

[@hasanghassan4308]

You have fixed my issue, thanks Chester

[@wayneedmondson1065]

Good tips! Thanks Chester. Thumbs up!!

[@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.

[@manojkumarm6609]

You Saved my time sir,thank tou❤

[@myintmoe-b8e]

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

[@bh844]

Miss the old Excel never had the Spill error

[@Patreon-rz9ed]

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

[@samadritashaw3352]

Thanks a lot! This helped me

[@ahmedmoatsem8355]

Many Thanks

[@IndianaBlu]

Thank you!

[@sushilgaikwad4338]

Thanks Chester

[@vipinpadiyan99]

Excellent usefull

[@chandrashaker309]

Thank you boss

[@dk-jq2iz]

Thanks Sir

[@malvinmohammad8395]

Thanks!

[@dhirajsinghchauhan4413]

Thanks a lot Chester

[@toshtosh2000]

Thank you so much!!!!!!

[@riderthakur]

Thanks a lot

[@arshiyaaashi1938]

Thanks alot

[@viveksinghgulia8739]

nice video

[@AB-qb6pt]

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

[@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

[@LalaLa-tn8do]

Tq