This is a new channel and I'd appreciate it if you'd help my channel grow by hitting the Like 👍 and Subscribe I hope you got value from the video 💡 Thank you for watching ⌚

I am a donkey and could not figure it out, but you made me understand it. Thank you

Have never used vLookUp earlier. But I'm quite confident of using it now, thanks to your easy-to-follow instructions. Keep it up.

Excellent presentation

@BossYourOffice

9 ай бұрын

Cheers

This was really helpful and your clear explanation about the column_id helped me fix to get it to work for me.

Excellent.

@BossYourOffice

10 ай бұрын

Thank you

Please always upload the exercise file. Thanks

@BossYourOffice

3 ай бұрын

Do you mean like an excel file that you can download and follow along?

@shoppersdream

3 ай бұрын

@@BossYourOffice Yes, Upload the excel file so that we can follow along. Thanks

can i explain about the short cut keys

@BossYourOffice

Ай бұрын

Hey! Here’s one of my videos on Excel shortcuts. kzread.info/dash/bejne/eHeFuLdwp62eodI.html

Hello, thanks for sharing this video on VLookup. I have been trying to solve a challenge on an excel spreadsheet where I had two sheets. One sheet contained the space where I am expected to input my data from using the VLookup formula and the sheet two is where my source data is located. Now, everytime I apply this formula to make sure that the cell reflects the lookup value I am looking for, it will return empty or a wrong value. What do you suggest I should do?

@BossYourOffice

9 ай бұрын

It could be because the lookup array and lookup value are not constant (using $) or the lookup values are not unique. Hope this helps. Ofcourse I can't be sure without going through your data files. Maybe watch my xlookup and hlookup videos for more example cases on how lookups work

Not working for me. Not sure what to do. Ugh! I get #N/A

@BossYourOffice

3 ай бұрын

It's likely there's a difference in the Lookup_Values

Hello, how can I contact you?

@BossYourOffice

8 ай бұрын

Hi, you can drop a comment here with your query

@AliAli-cc7vy

8 ай бұрын

@@BossYourOffice I need to transfer data from one sheet to another one using Vlookup, The first sheet has around 43 columns and I need only to transfer 20 columns and that contain specific rows values . Can you help me?

@BossYourOffice

8 ай бұрын

@@AliAli-cc7vy yeah basically you need to have the same unique field on both sheets. Use vlookup 20 times on each of the 20 columns that need in the new sheet

@AliAli-cc7vy

8 ай бұрын

@@BossYourOffice Thanks for your reply. I have 3 different values in the columns. S , T, - , I need to transfer only T ?

@BossYourOffice

8 ай бұрын

It's hard to say based on the info you have provided. I recommend watching the video again and also watching kzread.info/dash/bejne/g62H0Ll9nNm7fdY.htmlsi=iEW6JaCnl8OoKqls This way you'll understand the fundamentals and you'll be able to tackle any issue on your own

Thanks for explanation send me your email address as I have further questions on vlookup and pivot table thanks Armaan

@BossYourOffice

7 ай бұрын

Thanks. Please ask your questions here so that it may help others as well

@iamarmaankhan

7 ай бұрын

I wanted extra private lesson on vlookup that’s call

@BossYourOffice

3 ай бұрын

Hey sorry about the late reply. I was traveling. Please dm on insta @kennjoe

@iamarmaankhan

3 ай бұрын

Send me your email address thanks