Search Values in a Cell to Perform a Lookup on Specific Text

Have you done lookups before? Usually it's quite straight-forward...you have a value in a cell that you want to lookup up in another table but bring back an adjacent value that is aligned with it. The complication come when the cell you are looking up the value is full of other text and you just want to pull out or search for a define text and use that text as the looked up value. At first you may think that you'd need to have a helper column with a function to search out the right value and then another helper column to perform the lookup. Well this can all be done in one column with the LOOKUP and SEARCH function. It's almost like a wildcard search. I got this tip from Debra Dalgleish's contextures blog (check it out...she's got great Excel tips). See the video to learn how it's done.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel

#excel
#msexcel
#doughexcel

Видео Search Values in a Cell to Perform a Lookup on Specific Text канала Doug H