VLOOKUP with two lookup Values | Multiple Criteria in Lookup | Multilookup in hindi
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- Learn how to use the VLOOKUP function when you have more than one lookup values for each record.
Learn how to join two cells to add a new first column to the lookup table for the VLOOKUP function then us vlookup to find corresponding value based on that.
1. VLOOKUP with Two Lookup Values
2. VLOOKUP with 2 Lookup Values
3. VLOOKUP with multiple criteria
4. Perform a lookup with multiple critera
5. Using Iferror with vlookup
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookupwithtwolookupvalues#multicriteriavlookup #Innozant #exceltutorial
I wasted my 2 Days for finding the formula, used chatGPT but my problem is solved because of this video only, You are great sir, Thank you so much ❤❤❤
Thanks..Keep Learning and Keep Exploring 👍❤️
बहोत बहोत बढीया वर्क नया देकर खुशी पाता हे हम
Thanks Atul Ji🙏❤️
Respect from the bottom of my heart... 🙏🙏
Thanks dear ❤️
@@Innozant mention not sir...An excel aspirant from your videos
Bhai bht time se video search kr rha tha aj jakar sahe kam ke video mle thanks.continue your work.
Thanks dear...Happy Learning..Recommend you to start your learning journey from Playlist Baaic excel onwards.. We welcome you to experience the taste of success with Innozant-Seed of success
Sir, aapke energy levels and teaching style with smiles inspired us to do more. God bless you with all good health and happiness. , 🙏
Wah wah kya baat he
Namaste Sir Ji. you are making me clearly understand each & every concept in THE BEST WAY..
bahut bahut DHANYAVAAD aap ko mera
koti koti pranam...ji..
Anil from Bangalore
Thanks Deenabandhu ji..❤️❤️🙏🙏🙏happy learning
Bahut bahut dhanyawad sir for giving us such a video
really you are a great teacher
Thanks a lot
more i see you the more i get amazed with ur knowledge nd teaching prowess....
Thanks for such a lovely comment 🙏❤️
Very nice sir 👌 aap vlookup bahut acchy triky se smjhaty h
Thanks Jitender Ji❤️
Very useful information
How simple you make a thing for us!!!! It looks so easy the way you explain. Thank you..
Thanks Anup..Happy Learning 🙏❤️
bahut hi badiya description dia h...ur videos are really the best videos on youtube on excel...keep spreading ur knowledge ✌
Thanks Dear...God Bless you Really means a lot to me..Happy learning ❤️
it was an excellent approach sir ji , I dont have words to explain my gratitude in your respect sir, because it will be so less, reqeust you to keep this attitude and way of learning. so that we can learn like this. Pranam sir
Thanks Chauhan sahab..God bless you dear..Happy learning.
Excellent sir, your talent deserve,at least 1 lakh subscriber.
Thanks Jaspal Rana Ji,I am trying my best to Deliver the contents that definetly adds value in Learners life.
Thanks for wishes 😊
Best video I have ever seen
Thanks dear
Your explanation is amazing ☺️
Thanks Navya.. Really means a lot to me 👍❤️
Keep it up! Thumbs up from Pakistan
You are just great, Sir ji🙏🙏🙏
Thank you kitna kuch sikh patahun
great Guruji
Thanks great learning
Excellent Trick, Thanks for posting.
So many thanks sir this video class solve my problem विच I have asking today in comment box your other vlookup class
Great Rajeev ji👍
You are my ideal sir
Totally speechless amazing sir..thank you so much sir🙂🙂
Thanks Nisha..God bless u ❤️👍
Thanks... today I used this trick..Superbbbbb
Veey Good 👍👍🙏❤️
Excellent teaching
very imprssives video sir.
Thanks
Thank you sir 🎉 this trick very use full
I don't know how to thank you sir ❤
Mujhe mera solution mil gya😄😄😄🤪
Thats great Arun👍❤️
Amazing Sir... you are super.
very helpful
Great Sir... your all videos are awesome
Thanks Bhuwanta sahab♥️👍
Thank you so much Sir. This is great.
amazing video
Thanks sir
Nice explanation
Sir this trick is amazing
Superb sir ji
Thanks. For help
Thank you bhai
You are really great, Thanks a lot for such a wonderful content of Vlookup.
Thanks Mohit .have a great day ahead,🙏❤️
Good explanation Sir👏🙌
nice explanation sir.
keep it up.
thank you
Thanks Satish Ji.Happy learning
Sir agar condition slab mein ho agar 1-25, 25-50, 50-75...............?
Thanks sir
very great sir
Sir agar Puri row me formula ko drag karenge to ye kaam karega
Right side me jo formula apne lagya wo
Agar data range badi ho or size l or m ho or product name duplicate ho to
Jese
Shirt shirt
Jeans jeans
Coat coat
thank you baiya
Thanks dear❤️👍
Super very helpful thanks
Thanks Mohan
@@Innozant sir I want to know which position of u in text TH-cam mujhe tube se Jo 'U'hai use position chahiye pelha 'U' Jo hai you is me nahi to yen kaise kiya jaye pls explain
Thank you it really helped
Thanks Santosh ji🙏❤️
Thank you; learned a lot
Thanks Sujit Ji🙏❤️
It was an excellent explanation,can you do a video using two lookup date and time as data. It will be very useful in vlookup
Ok Wasim..will add your request in upcoming vidoes
Excellent
Can we do it without helper column, kindly suggest
Thnx
Hi. Can we use 2 lookup values in vlookup fuction where one lookup value is date and another is text
oooo sir you are jhaka naka 😚
Sir isko hum DGET function se kare toh koi issue toh nahi hoga
Sir✌️❤️
Nice
❤️
Just a opinion, can we use concatnate formula to merge the two values & then after removing the paste special values, Can we then perform a vlookup accordingly, i guess even that would give the required value, Sir please correct me if i am wrong ?
V.Good...😊
Nice trick 🙂🙂
Thanks .Hv a nice day🙏🙂
it was an excellent approach sir ji,,,,but can u please tell me if any other way to use vlookup with two lookup value without using any merging anywhere.??
Sir how do you add that helper column to the table???
By using formula
=B4&"l"&KARTIK
Sir how can we use date as another lookup value ? i am taking date as another lookup value and separating it in one cell but format of date is getting change so i am unable to find result. If possible please help me
वैसे मुझे बिहारी पसंद नही लेकिन आप काम अच्छा कर रहे हैं।
Please help 2 values ki bicha values ko ek column m kese find karenge
Thanks for explaining, is it possible to solve without using helper column.
Yes it is possible..will surely upload video for the same
How can use vlookup with 2 lookup values without using helper coulmn and return single value?
I also tried 3 way look up. And I successfully applied, but when I try to find the further records using columns , its showing NA, may I know the reason behind this dear sir
SIR SAME PROCESS GIVES ERROR WHEN WE TRY TO PULL DATA IN SHEET 2 FROM SHEET 1
Odd even number per row and coulam ka use kaise kare
Sir how to do same when other column is DATE colum?
I want to find the value of c1 d1 in column A AND B
A1=12. B1=32. C1=21 D1=25
A2=21 B1=25
sir can we use DSUM method here ?
Sir,
Two students with same name is possible but two students with same roll number how it is possible. 10103 is Anika, 10103 is again for Suman !
Sir, Can you suggest me any way to use lookup function when the lookup value is in a merged cell?
Merged cell are just formattingone approach would be a helper column .
Say the vlookup target is col A and Col B contains merged values.create a helper column in C and apply the formula..
Ok will try to add this in any upcoming videos.
all formulas advance excel uplood korun .
Same roll no(Same ROLL NO.) do Alag alag students ke kaise ho sakte hain??
Guru ji vlookup se 3 table se data uthana h or jo common data h vo aage piche h to kese data pick karenge 3 table se 3 data pick karna hai please send link about this consern
Thanks a lot sir
Nicely explained
Need help
I have a data which has multiple table array but only one has value and others are blank
In return it gives blank as answer
Can u assist
Share your sheet @innozantofficial telegram id.Will see
I did it by using concatenate function....
=VLOOKUP(CONCATENATE(B13,C13),$A$4:$D$9,4,FALSE)
very good dear
Sir without helping column kse karenge
Sir esko agar index se krna hoga to kaise kre maine bohot try kia but nhi ho raha
Can we do it without using Helper column
Yes we can
👏
Sir kya hm esse index or match se kr skte hai?
Kisi bhi function se kiyabja sktabh solution dear
Sir isme kuch value dikhti hai
Kuch nhi aati
For ex
Payal G
Payal S
Ye 2 lookup value hai same name but symbol change hai
Inka HSN code alag alag hai lekin error aa raha hai
Plz helpppppppppppppppp
Koi other method hey for same result??
Company Name || Location || Purchaser
AMAZON TX 8
Amazon India 7
Amazon TX 5
Amazon Inc. GA 4
I have two tables. One is above & in second table I have just company Name & Location.
Condition: If Company Name & location Matches, Then Highest purchaser number should appear & If location is not found, then also the highest purchaser value should appear.
How to get it??
Without helper column i use vlookup +choose advance
App se hi sikha hai sir je advance unique formulas lagane hahaha
👍👍
Why did you use "-" in next question instead of "/"?
Sir i want to solve this without helper pls suggest
Can we get the output without helper column?
Yes we can
@@Innozant Thanks Sir I have tried with CHOOSE function and got the output.
Sir, which formula to use if we want to find out employee name based on region and with highest sales. I tried with xlook up with large but then I can’t select region. I understand if we apply filter we can sort by region but how to use formula without applying filters.
Pls advise
Thanks in advance
Using vlookup even we can do the same..why there is need of XLookup or filter Kavita ji
How do we do using vlook up ?
like banta hai