5 Bite-Size Vlookup Tricks for Excel - Workbook Included

Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
5 tricks for using Vlookup on data that might not always be 'friendly.'
This includes:
Removing extra spaces.
Working with multi-part lookup values.
Dealing with Vlookup errors.
Removing extra characters.
Fixing Text/Number value issues.

[@sandip_bettereveryday]

Loved that 'in-cell' number to text and text to number conversion. Really smart.

[@TeachExcel]

Thanks! Glad you like it :)

[@alexrosen8762]

All your tutorials are super useful! Thanks a lot :-)

[@TeachExcel]

Thanks so much for the support :)

[@narayanmeena5419]

Best of excel tips are here. 👍

[@sachinrv1]

I really liked the part where you used ""& to convert number in general format in text format before applying vlookup

[@sanathsaja9840]

Good lesson

[@404ErrorPage]

Great tips. Thank you.

[@TeachExcel]

You're welcome :)

[@MrSojek]

I still cannot figure out why sometimes the table array is set with absolute references or why people include column headings. When you prepare for MS excel expert exam it can be confused as you don't know how testing software will mark your answer.

[@NirmalKumar-xq5es]

Nice

[@TeachExcel]

:)

[@mahaboobhossain5076]

I NEED THIS FILE BROTHER PLZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

[@TeachExcel]

Click the link in the description next to where it says "Excel File:" :)

[@lingshuangzhang362]

This video ends my Vlookup nightmare!