Use VLOOKUP to Lookup a Value to the Left

Подписаться 79 тыс.

Просмотров 63 тыс.

50% 1

This video show how to perform a lookup with the VLOOKUP and CHOOSE function to bring back a value to the left. The VLOOKUP function normally brings back values to the right of a table, but this "hack" using the CHOOSE function will let you bring back a value to the left of a table.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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 www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 85

@DougHExcel 5 лет назад

For more videos that cover lookup concepts see the playlist at ru-vid.com/group/PL-n8f1cY_Qw95JHWjCjPofsCd7hCWjI8l

@DougHExcel 4 года назад

...

@hta3139 11 месяцев назад

Thank you so much for this!! 8 yrs later still the best solution

@DougHExcel 11 месяцев назад

Hi Hta, thanks for the kind words!

@weatheringcloud7191 2 года назад

THANK YOU SO MUCH! I've been looking for a video that allows me to understand the choose function for so long, every other video that does this formula for the vlookup to look to the left just do it without explaining what CHOOSE does, but now it just makes sense in my head. We're creating a table array that re-organises our data to have the value on our left-most side appear on the right, and our column index then picks that value as it normally would. Bless you my guy

@DougHExcel 2 года назад

Thanks, glad you found it useful!

@NotWorthyofBeingWatched 9 лет назад

I saw another source before I saw your tip. Your explanation opened my eyes! No more having to make multiple lookup source tables with the same data and re-arranged columns. Thank you so much Doug.

@amitgautam52 8 лет назад

Hi Doug, Thanks to upload VLOOKUP to Lookup a Value to the Left. I have search this from long time.

@DougHExcel 4 года назад

Thanks Amit Gautam, glad it helped!

@AbdulGhaffar99 3 года назад

Great Thanks A Lot it solved my old problem in simple way...

@DougHExcel 3 года назад

Glad it helped!

@tzoulianpougios7062 3 года назад

Thanks for this video saved me so much headache 🙏

@DougHExcel 3 года назад

Glad it helped!

@jazzista1967 8 лет назад

Doug: Bravo! So you are basically tricking VLOOKUP with choose to iterate 2 columns of values : value 1 the right most column and column 2 with the values to the left. Great trick. I thought you would be entering CSE since you are creating an array.

@DougHExcel 4 года назад

Hi jazzista1967, thanks for the comment!

@Nailesh232 9 месяцев назад

Thank you Doug!

@DougHExcel 9 месяцев назад

Welcome!

@velavanselvamani3387 5 лет назад

Thanks for the info.. it's helpful

@DougHExcel 5 лет назад

Thanks velavan selvamani, glad it helped!

@miriambonilla2371 9 лет назад

Thank you. It was a great tip.

@giacomosicardi1101 2 года назад

well explained, thanks for the help

@DougHExcel 2 года назад

You bet!

@ronnieandales8045 4 года назад

This helped a lotto make my project done. Thanks!

@DougHExcel 4 года назад

You're welcome!

@zhaoyangli1908 2 года назад

very helpful! Thanks Doug!

@DougHExcel 2 года назад

Thanks!

@anhto7623 5 лет назад

Thank you for sharing your knowledge. This is very useful!

@DougHExcel 5 лет назад

Hi Anh To, thanks for the comment!

@husbyhogan 8 лет назад

Thanks Doug, very easy solution and very helpful!!! Thanks for Sharing. Excel is Gr8!

@DougHExcel 4 года назад

Hi JKO, thanks for the comment!

@husbyhogan 4 года назад

@@DougHExcel you are most welcome 😀👍

@crazyarmy377 3 года назад

Thank u sir it helped me a lot.

@DougHExcel 3 года назад

Glad to hear that!

@rajeevgosavi4514 2 года назад

Could you pleasegive a link to download worksheet to follow along. Thanx

@melaniejohnson4106 7 лет назад

thank you so much!!!!! i have been trying to find this trick and it worked!!

@DougHExcel 7 лет назад

You're Welcome!

@carlslade5730 9 лет назад

Thanks Doug, very cool.

@mrkaddo 6 лет назад

Thank you! This was very helpful.

@DougHExcel 6 лет назад

Thanks M R, glad it helped!

@emanalbar 9 лет назад

thank you Doug.

@itsjustme17hithere 6 лет назад

wow! so very helpful! thank you so much! :)

@DougHExcel 6 лет назад

Hi rChan, glad you liked it, thanks for commenting!

@muralichimala9033 8 лет назад

very good and useful for me..

@stevesullivan457 9 лет назад

Great stuff Doug! Is it ok to use column header cells as part of these formulas. I noticed you did not. Thanks

@Kildergcowboy 5 лет назад

Excellent stuff. Thanks!

@DougHExcel 5 лет назад

Hi Paul Flood, thanks for the comment!

@MatthewLuna 4 года назад

THANK YOU SO MUCH!

@DougHExcel 4 года назад

You're welcome!

@chadgbeats 4 года назад

Tutorial starts at 4:10

@DougHExcel 4 года назад

Hi Chad G, thanks for the feedback!

@BadMitzi 5 лет назад

Thank you, sir! One question: does the table needs to be sorted in any kind of way? Or it doesn’t matter, since we’re using absolute reference for the array?

@DougHExcel 5 лет назад

No sorting needed as it will will report back the first matching instance

@BadMitzi 5 лет назад

Doug H thank you so much!

@dineshmcv1 8 лет назад

thank you. i have a doubt!?? Is that possible to explain how to vlookup the data from the two different sources at once? hope u can understand my question!!!

@DougHExcel 4 года назад

Hi Dinesh D, thanks for the comment!

@1gopalakrishnarao 9 лет назад

You have mentioned the website name. Please give the reference.

@thanveervp940 8 лет назад

Thank you

@DougHExcel 8 лет назад

You're welcome!

@sundaysharing 4 года назад

Did not work for me. I had to go to INDEX, MATCH. I use Office365.

@DougHExcel 4 года назад

Hi Sridhar J, thanks for the feedback!

@paulsaunders7918 3 года назад

If you have Office365 use XLOOKUP!

@susando2943 6 лет назад

Hi Doug in this example, how would you find the values under column 2013?

@DougHExcel 6 лет назад

as part of the choose function, select the range for column B instead of column C that was shown in the video.

@susando2943 6 лет назад

Doug H hi Doug thank you so much for your reply. The lookup value I have is in a different sheet and this formula is not working. It’s saying there is a missing parenthesis but I can’t figure out where to put the brackets. So u know how we can use vlookup and choose of the data is in a different sheet or workbook?

@forfunwee 3 года назад

I think I'm doing something wrong. I'm trying to do this across two sheets and it isn't working (i.e. two sheets in the same workbook).

@DougHExcel 3 года назад

Should work...

@Fajriah 7 лет назад

Hi, i try the method, but it doesn't work. My computer format is " ; " instead of " , " . How do you think " {} " should be changed to? I try to gooling to change the format, but still find nothing.

@DougHExcel 4 года назад

Hi Fajriah, thanks for the comment! See the other lookup video link at the end of this video for other resources.

@dianachua4940 9 лет назад

Doug, I think LOOKUP is easier in this case.

@sumitguha803 5 лет назад

How i get the excel workbook downloaded

@DougHExcel 4 года назад

Hi Sumit Guha, sorry don't have files to download :-(

@123coller 3 года назад

Why am I having an out of bound range? =VLOOKUP(G3,CHOOSE({1,2},$E$3:$E$20,$C$3:$C$20),2,FALSE)

@DougHExcel 3 года назад

Try exact match the last argument is TRUE

@guilhermefilho 5 лет назад

It did not work for me

@guilhermefilho 5 лет назад

Just found the error, depending on the version/configuration of Excel, the array notation is different, in my case {1/2} instead of {1,2}. Spent all afternoon to find that :(

@DougHExcel 5 лет назад

Hi Guilherme Filho, good to know...thanks for adding to the thread

@mathiassoderlund9951 5 лет назад

it won't work for me here is my formula: =VLOOKUP(F22, CHOOSE({1,2},$B$21:$B$24,$A$21:$A$24), 2, FALSE)

@mathiassoderlund9951 5 лет назад

Also I use Google Spread sheet

@DougHExcel 4 года назад

This might not apply to google sheets. Maybe if there is an equivalent of INDEX/MATCH on Google, that might work for you. See INDEX/MATCH video for EXCEL here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9E6Npfdp5S8.html