No video
Advantages of Using Column Headers in Vlookup
How to use column header labels in Vlookup for more interesting and accurate data analysis in Excel. You can get more details here: www.exceltrain...
How to use column header labels in Vlookup for more interesting and accurate data analysis in Excel. You can get more details here: www.exceltrain...
Пікірлер: 44
Thank you so much Guruji 👨🏫. Please keep share useful information. Many many thanks God bless you.
@Exceltrainingvideos
2 жыл бұрын
Always welcome
Everything you explain is useful and new. Greetings from Egypt
@Exceltrainingvideos
2 жыл бұрын
Awesome, thank you!
Thanks sir for uploading useful information.
@Exceltrainingvideos
2 жыл бұрын
Always welcome
Thanks for valuable tip.
@Exceltrainingvideos
2 жыл бұрын
You're welcome!
First my morning wishes sir. Inspiration your teaching and programming. I am addicting your teaching. Thank you so much sir.
Thank you sir. It is great trick.
Thanks 👍 it's very helpful to me
@Exceltrainingvideos
2 жыл бұрын
Most welcome 😊
Thanks sir, it is very much useful for me
@Exceltrainingvideos
2 жыл бұрын
Glad to hear that
This is great, thank you ! Will share with my colleagues!
@Exceltrainingvideos
2 жыл бұрын
Thanks for sharing!
Thank you sir. but how to use vlookup using table header to a userform? Please give me a soluation.
Sir it is very useful but a separate video for the same using video please
@Exceltrainingvideos
2 жыл бұрын
Ok sure
Even if we do not include column headers in the "Vlookup" function and use match function for headers, the formula will still work!!
@Exceltrainingvideos
2 жыл бұрын
Try interchanging the columns!
@rehanshah2091
2 жыл бұрын
@@Exceltrainingvideos Still works :)
Sir I am maintaining a spreadsheet for stock and inventory... I am having 6700 items and I was maintaining well by using vlookup and if formulas but my project manager added a new criteria that I have to maintain bin location where the material is located. Issue is that one item is located in many bins and I have to give stock report by unique items. Plzzzz help me...
@Exceltrainingvideos
2 жыл бұрын
Use XLookup: kzread.info/dash/bejne/iICBzpqYZdfegtY.html
Great
@Exceltrainingvideos
2 жыл бұрын
Thanks
Sir, do let me know if u run any macros courses
@Exceltrainingvideos
2 жыл бұрын
yes
Sir, one query in vba pls help on this, I have 3 listboxs in userform atleast i need to select anyone item among 3listboxs then only I can click optionbox if I ll not select any items in listboxs it should populate msgbox. How I need to proceed for this??
@Exceltrainingvideos
2 жыл бұрын
St the option button's visible property to false. Now use an IF condtion like so: If ListBox1.Value = "SomeValue" Then OptionButton1.Visible = True
@lavanyakuppuswamy4938
2 жыл бұрын
@@Exceltrainingvideos sir i tried but its not working as expect. I don't wanna hide option button. I need to get popup msg if none of the item not selected in listbox 1 and listbox 2 I tried like this Optionbutton1. Click If listbox1. Listindex & listbox2. Listindex =false then Msgbox "Before select option button please any items from listbox 1 or listbox 2" End if But this loop not work properly. Please help me.
@lavanyakuppuswamy4938
2 жыл бұрын
@@Exceltrainingvideos could you please help on above query 🙏🙏🙏
@Exceltrainingvideos
2 жыл бұрын
@@lavanyakuppuswamy4938 www.exceltrainingvideos.com/excel-vba-combobox-match-required/
@lavanyakuppuswamy4938
2 жыл бұрын
Thank you so much for your time and updates. Yes I tried as you told but it didn't worked as I expected. I tried like, If listbox1. Listindex=-1 or listbox2. Listindex=-1 Or listbox3. Listindex=-1 then Msgbox "pls select any value" End if
Sir I have one big data file like time range file employee scan time list This file header fist sheet I'd number, scan time, remark Seconds sheet time and remark examples 7:00:00AM to 9:00:0AM = beak time 1:00:00PM to 2:00:00PM = lunch time... Please make one vedieo for fuilly automatic vba format sir
@Exceltrainingvideos
2 жыл бұрын
This Excel tutorial will guide: www.exceltrainingvideos.com/payment-calculations-based-on-timestamps-in-excel/
@krishnajagadeesh6307
2 жыл бұрын
Okay sir
Hello. This is useful, but why not directly use index/match or, if possible, xlookup ? Even that, thank you for sharing your skill.
@Exceltrainingvideos
2 жыл бұрын
Yes, you are right
@hbp7633
2 жыл бұрын
Bro 😎 XLookup is not available in all version, don’t you know this bro bro 😎
@Exceltrainingvideos
2 жыл бұрын
@@hbp7633 Did I use XLookup in this video?
@hbp7633
2 жыл бұрын
@@Exceltrainingvideos. Guruji I have written to someone else not you. See the top comment above. I m telling him that XLookup is not available in all version. You are excellent.
@dd1965
2 жыл бұрын
@@hbp7633 I know Xlookup is not always available, that's why I said "if possible " bro.