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.
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.
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.
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
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)?
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
भाई इसका क्या 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 आए
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
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
This is great, this can look for and return for multiple cells ❤thank you
I fall in the 99% that didn't know this trick (until now)
😮 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!
Before I was using lookup formula again and again but now it's easy😅
Thank you🤗
*Properly working sir...Thankyou so much❤*
Welcome 👍
Thanks so much dear
You can use match formula within the vlookup if your columns are not in the same order.
Great job! TY
Wow! this is my first time seeing this
If I can see for whole full table. Multiple columns and for multiple rows
Thanks bro I like Indian tricks
Kaash ye video kal aa gaya hota mere samne .......Aaj same question test me aaya tha chhor ke aa gaye 😢
The number of characters typed for the vlookup formula is almost equal to typing the actual characters values into the cells.
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!
DON'T forget to like this video. Ye sunne me maza aane lagg gaya hai.
How did you know 99% of the excel users don’t know this??
In my office we have known this for 2 years+
Sir please make videos on each and every formula please
Yes sure
Choose formula can also do that.
Wow, that is a cool feature!
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
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.
You can use Vlookup with Match function bro
If you change the Column Hedders then It will pick the results automatically.
maybe it works only in excel, but in Libre office it does not work
I'm not getting results, what you are explained. Getting only content of column 2.
same
Triple data entry n ho iska kya upay h excel me
Nice trick,it's very useful to me.
Glad to hear that
Really great help to us
Thank you🤗
Superb, Sir I have to collate 20 excel's in single sheet. Is there any option please
Thank you so much Bro
Welcome
I want you to teach me how to create new date type
Which datatype you want to create?
Bro when i need column header based result it wont work bro why your are using statistic way
Is it work in another sheet ?
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.
Which Excel version are you using I tried but not working
I am using Excel 365.
Hey dear, I have tried and I couldn't make it, any assistance please?
Awesome, but mine use index match
Oh nice
D-get better than Vlook up?
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...
Useful
Glad you think so!
While inserting formula shall i have to select all the 3 cells or single cell and then ctrl+d
Awesome tricks 👌
Thank you
Thanks
Welcome
kuch kuch hota hai 😍😍😍
from which excel's version this format can be used?
Nice, mera kaam ho gaya 👍
Can this work on typing the names and automatically add the salary
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
U r really champ 🏆 man 💪, superb
Thank you so much 😀
Only name a raha
thank you
VLookup means vertical lookup value
HLookup means horizontal lookup value ❤ likes 1.5k
Good😊
Thank you! 😃
it is so good
Good.
Thanks
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.
Great brother
awesome content!
Bro it's even easier with xlookup
In which version it's work bro
Excel 365
Nice trick....but we can apply vlook up once and then copy in each cell
No need to, with this trick.
THANK YOU BOSS
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
Useful...
Keep watching
Nice to know
Thank you
you need to press cntrl+shift+enter not enter
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 ?
Instead of that we can use filter formula
what if its in another sheet?
Good
Thanks
भाई इसका क्या 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 आए
Super
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
How are you sure 99% doesn't know it?
Maximum doesn't know.
@@Shortandclearexcel what data do you rely on to be so certain using curley brackets within VLOOKUP isn't know by 99%?
Nice
Thanks
Sir kya aap excel full course ki video baate hai.
I will create full course video in future.
Cam use for Xlookup
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
Very helpful bro
Thanks sir❤
i use match function at index no place
Never seen this trick
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
Hello bro in entire excel sheet using the code how to get details
It doesn't work in Office 2021
Ham tho copy past kardetey ye ithna formula typing ka time nahi 😮
Mere Excel par kyo nahi ho raha haj
But why use this formula...?
Why can't we use "Find" ctlr+F and just find the no. we want. ???
Can also apply filter formula
Hi ,how take other sheet data using same format
It's not working on Excel 2013 bro
How the excel is empty all other places except at two tables
I know that this is multi vlookup
Oh no, why i didn't see it before 😢
Just fill right you will get the same results
Wahh bhai
we can use DGET function also right?
how?
Use advance logic
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
99% people doesn't watch this video becoz they already know 😂😂😂😂😂😂
I didn't know 😅
Yes, I does know 🤪