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 💡Join our FREE newsletter for even more value! boss-your-office.ck.page/sign-up Thank you for watching ⌚
@if4636
5 ай бұрын
I am a donkey and could not figure it out, but you made me understand it. Thank you
@alexandrenguimfack3563
2 ай бұрын
very good, thank you
@denme5
6 ай бұрын
Not working for me. Not sure what to do. Ugh! I get #N/A
@BossYourOffice
6 ай бұрын
It's likely there's a difference in the Lookup_Values
@tnssajivasudevan1601
Жыл бұрын
Excellent.
@BossYourOffice
Жыл бұрын
Thank you
@AliAli-cc7vy
11 ай бұрын
Hello, how can I contact you?
@BossYourOffice
11 ай бұрын
Hi, you can drop a comment here with your query
@AliAli-cc7vy
11 ай бұрын
@@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
11 ай бұрын
@@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
11 ай бұрын
@@BossYourOffice Thanks for your reply. I have 3 different values in the columns. S , T, - , I need to transfer only T ?
@BossYourOffice
11 ай бұрын
It's hard to say based on the info you have provided. I recommend watching the video again and also watching kzitem.info/news/bejne/sq-J1It6paiGgKgsi=iEW6JaCnl8OoKqls This way you'll understand the fundamentals and you'll be able to tackle any issue on your own
@healthywalletz
Жыл бұрын
Have never used vLookUp earlier. But I'm quite confident of using it now, thanks to your easy-to-follow instructions. Keep it up.
@venkateshchintagunti4236
3 ай бұрын
How to create in 1excl sheet? From Different sheets data!
@BossYourOffice
3 ай бұрын
Hey! It works the same way even if it’s on the same sheet. Just find the search parameter, the table with the search item and result and use the formula. Here’s another shorts video I posted… maybe a different perspective will help… kzitem.info-dX2QUgMYKw?feature=share
@RVDL
11 ай бұрын
This was really helpful and your clear explanation about the column_id helped me fix to get it to work for me.
@Speechout4
Жыл бұрын
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
Жыл бұрын
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
@starlordgamer
4 ай бұрын
can i explain about the short cut keys
@BossYourOffice
4 ай бұрын
Hey! Here’s one of my videos on Excel shortcuts. kzitem.info/news/bejne/p3mHvIltsHxppKQ
@shoppersdream
6 ай бұрын
Please always upload the exercise file. Thanks
@BossYourOffice
6 ай бұрын
Do you mean like an excel file that you can download and follow along?
@shoppersdream
6 ай бұрын
@@BossYourOffice Yes, Upload the excel file so that we can follow along. Thanks
@72nukey
Жыл бұрын
Excellent presentation
@BossYourOffice
Жыл бұрын
Cheers
@iamarmaankhan
10 ай бұрын
Thanks for explanation send me your email address as I have further questions on vlookup and pivot table thanks Armaan
@BossYourOffice
10 ай бұрын
Thanks. Please ask your questions here so that it may help others as well
@iamarmaankhan
10 ай бұрын
I wanted extra private lesson on vlookup that’s call
@BossYourOffice
7 ай бұрын
Hey sorry about the late reply. I was traveling. Please dm on insta @kennjoe
Пікірлер: 31