Don't Use Vlookup in Excel‼️Instead Use Amazing Function
ฝัง
- เผยแพร่เมื่อ 16 ก.ย. 2024
- In this video, you will learn how to use Advance Vlookup in Excel.
Join Telegram Channel to Get Excel Practice Sheets:
t.me/shortandc...
Join my TH-cam Membership: Click on link below:
/ @shortandclearexcel
#excel #exceltricks #exceltips #exceltech #excelformulas #excelworld #excelgyan #microsoft #msexcel #microsoftexcel #exceltutorial #excelhacks #exceladvance #advancedexcel
Amazing!
Vlookup, vertical look up
H look up horizontal
X look up combination
Thanks, will do!
I’ve never seen anyone with that use case. Xlookup would be more versatile
Thank you for your suggestion.
In the new Excel version. Not available in Excel 2007
My office only has Excel 2016, so no Xlookups for us 🫠 So this is a useful tip!
@@shameerpk7 I dont think old excel supports array formula either lol
@@williamantonio9743 supports vlookup
😮 brother "does not" is not correct, "do not" is right.
But the info you are giving, is very precious.
Thank you very much.
Poor at English grammar!
I fall in the 99% that didn't know this trick (until now)
*Properly working sir...Thankyou so much❤*
Welcome 👍
This is great, this can look for and return for multiple cells ❤thank you
How did you know 99% of the excel users don’t know this??
In my office we have known this for 2 years+
It is just a keyword.
Great job! TY
You can use match formula within the vlookup if your columns are not in the same order.
Nice tip. You got new subscriber
99%?? I'm guessing that you made this up. A certain irony when you're demonstrating a statistical package. Prove me wrong and show us all your research.
Thanks for the sub!
Before I was using lookup formula again and again but now it's easy😅
Thank you🤗
If I can see for whole full table. Multiple columns and for multiple rows
Thanks bro I like Indian tricks
Sir please make videos on each and every formula please
Yes sure
Wow! this is my first time seeing this
Superb, Sir I have to collate 20 excel's in single sheet. Is there any option please
Don't use Vlookup.. proceeds to use Vlookup ..
It gives me result vertical, not horizontal. How can I solve it?
The number of characters typed for the vlookup formula is almost equal to typing the actual characters values into the cells.
Nice one , can you explain why 2,3,4 ?
2, 3 and 4 are column index number.
1 index number - Code
2 index number - Name
3 index number - Department
4 index number - Salary
Nice trick,it's very useful to me.
Glad to hear that
Wow, that is a cool feature!
What is this 2,3,4 and 0??? Can anyone tell me this? Please.
the column to be filled or the column from where the informations will be picked
You have to put column numbers from table array from where you want your output and 0 is false which is for exact match means output won't be available if there are errors in your input. 1 or true for approximate match.
Really great help to us
Thank you🤗
Hey dear, I have tried and I couldn't make it, any assistance please?
Can this work on typing the names and automatically add the salary
I'm not getting results, what you are explained. Getting only content of column 2.
same
Awesome tricks 👌
Thank you
I want you to teach me how to create new date type
Which datatype you want to create?
Thankyou very much...pls tell me one thing bro that do we able to use this in INDEX MATCH.
And it's not working in my excel...now what should I do for this...
While inserting formula shall i have to select all the 3 cells or single cell and then ctrl+d
Is it work in another sheet ?
Triple data entry n ho iska kya upay h excel me
let's say i have another data after salary which is address, and i need to skip salary in vlookup how can it be done ?
D-get better than Vlook up?
maybe it works only in excel, but in Libre office it does not work
Thanks so much dear
Bro when i need column header based result it wont work bro why your are using statistic way
VLookup means vertical lookup value
HLookup means horizontal lookup value ❤ likes 1.5k
Thanks
Welcome
Thank you so much Bro
Welcome
Amazing bro
Thank you so much 😀
Hello bro in entire excel sheet using the code how to get details
How come, that in my Excel similar formula results with a vertical output array (spanning through C15, C16 and C17), and not with a horizontal one, as in your movie (C15, D15, E15)?
I observe the same vertical behavior in LibreOffice Calc too.
U r really champ 🏆 man 💪, superb
Thank you so much 😀
Only name a raha
You can use Vlookup with Match function bro
If you change the Column Hedders then It will pick the results automatically.
If the D14 has entered another data like tellphone number but it should be enter manually or another way(1st table has not that data).can i apply this for new chart
Useful
Glad you think so!
from which excel's version this format can be used?
awesome content!
Sir kya aap excel full course ki video baate hai.
I will create full course video in future.
thank you
Awesome, but mine use index match
Oh nice
Good.
Thanks
Can we use this in multiple rows? I tried but its Spills over
I think you are inserting more column data in one go. If you're getting spill error then what you can do is just insert more columns for your vlookup data.
Good😊
Thank you! 😃
Great brother
Which Excel version are you using I tried but not working
I am using Excel 365.
Sir, if i right two dates, for example 19-08-2006 to 31-12-2023, now i want to get only 1 July and 1 December of each year from 2006 to 2023, how can i get? Plz healp.
31-12-2006
01-07-2007
31-12-2007
01-08-2008
31-12-2008
And onwards till 1-12-2023, in same row , horizontally sequence
In which version it's work bro
Excel 365
Choose formula can also do that.
Nice trick....but we can apply vlook up once and then copy in each cell
No need to, with this trick.
i use match function at index no place
you need to press cntrl+shift+enter not enter
Super bro.. does this work in 2019 excel??
Yes
It is not working in 2019. Followed your instructions, but it was not working.. help me if you can.
Yes it is not working , help me to fix it one
@@rajukarthikeyan4065 you have to press ctrl Shift enter
@@mydeenmydeen-pv2ixafter formula don't press just enter press ctrl Shift enter
Cam use for Xlookup
Can also apply filter formula
Instead of that we can use filter formula
Nice to know
Thank you
Nice, mera kaam ho gaya 👍
Good
Thanks
it is so good
what if its in another sheet?
Nice
Thanks
Useful...
Keep watching
Super
Hi ,how take other sheet data using same format
kuch kuch hota hai 😍😍😍
You can use xlookup Instead
Sure
Bro it's even easier with xlookup
THANK YOU BOSS
Very helpful bro
But why use this formula...?
Why can't we use "Find" ctlr+F and just find the no. we want. ???
How the excel is empty all other places except at two tables
It’s not working in my spreadsheet
You will have to highlight the empty cells you want to return before inputting ya vlookup formula then, instead of hitting enter to execute, you use ctrl + shift+enter. This is to inform the system that you are executing an array formula
It's not working,
I only understand that instead of vlookup I should use vlookup... is that what it's about?
Advance Vlookup
@@Shortandclearexcel Don't Use Vlookup 😁😁😁
I honestly thought You would show these functions in the video: XLOOK or FILTER.
Sure
not working... can you explain why?
भाई इसका क्या solution है ❓❓
जैसे मैं date लिखता हू 1 may fir iske niche 2 may, fir in दोनों को select करके mouse se नीचे तक drag कर deta हू मान लो मैंने 10 tarikh तक drag kar diya ( 1 se 10 tarikh tak date dal gai)
Ab isi line me mujhe kahi bhi bich me date change karni h मान लो जहां 4 may ki date likhi hui thi वहाँ 6 likh du, to automatic 6 jan बन jayega, jabki मैं चाहता हूं कि 6 likhte hi 6 jan ki जगह 6may आए
we can use DGET function also right?
how?
Never seen this trick
Thanks sir❤
Why u hitesh is coming on the top since his salary is in between range .. na higher na lower hai. Can u make me understand
DON'T forget to like this video. Ye sunne me maza aane lagg gaya hai.
Mere Excel par kyo nahi ho raha haj
Kaash ye video kal aa gaya hota mere samne .......Aaj same question test me aaya tha chhor ke aa gaye 😢
It's not working on Excel 2013 bro
It doesn't work in Office 2021
Use advance logic
99% people doesn't watch this video becoz they already know 😂😂😂😂😂😂
I didn't know 😅
Yes, I does know 🤪