Fix VLOOKUP

Download the featured file here: www.bluepecantraining.com/wp-...
In the video I show you how to fix the #SPILL! error when using VLOOKUP. The #SPILL! error indicates that there is not enough cells for the formula to display its results in. Excel 365 supports dynamic array formulas where a single formula is capable of displaying multiple results. The array of results are spilled into surrounding cells.
Excel 365 warns users that get this error that the formula they have entered may spill beyond the edges of the worksheet. This warning occurs when the user selects an entire column in the lookup_value argument and the VLOOKUP has been typed into a row other than row 1.
Excel offers to correct the formula with an '@' symbol in front of the lookup_value. The '@' symbol forces an implicit intersection where multiple results are collapsed down into one. The result that is displayed is the one that shares the same row as the formula.
------------------------

[@kingpinn13]

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

[@lmajiedmary]

I have been to a vast array of teachers on KZbin 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!!

[@IvanCortinas_ES]

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

[@jramaswamy]

Excellent lesson. Simple and straightforward. Thank you.

[@kismenarchannel]

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

[@user-kr4kw1jt6w]

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

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

[@wayneedmondson1065]

Good tips! Thanks Chester. Thumbs up!!

[@dhirajsinghchauhan4413]

Thanks a lot Chester

[@user-km5mx1eb7e]

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

[@hasanghassan4308]

You have fixed my issue, thanks Chester

[@toshtosh2000]

Thank you so much!!!!!!

[@user-bl5fi1zx9q]

Thank you!

[@ahmedmoatsem8355]

Many Thanks

[@sushilgaikwad4338]

Thanks Chester

[@samadritashaw3352]

Thanks a lot! This helped me

[@chandrashaker309]

Thank you boss

[@bh844]

Miss the old Excel never had the Spill error

[@malvinmohammad8395]

Thanks!

[@manojkumarm6609]

You Saved my time sir,thank tou❤

[@riderthakur]

Thanks a lot

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

[@dk-jq2iz]

Thanks Sir

[@vipinpadiyan99]

Excellent usefull

[@viveksinghgulia8739]

nice video

[@LalaLa-tn8do]

Tq

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

[@arshiyaaashi1938]

Thanks alot