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 ❤❤❤

@Innozant

10 ай бұрын

Thanks..Keep Learning and Keep Exploring 👍❤️

Bahut bahut dhanyawad sir for giving us such a video

Excellent Trick, Thanks for posting.

Sir, aapke energy levels and teaching style with smiles inspired us to do more. God bless you with all good health and happiness. , 🙏

You are my ideal sir

You are just great, Sir ji🙏🙏🙏

Keep it up! Thumbs up from Pakistan

Thank you so much Sir. This is great.

Amazing Sir... you are super.

Bhai bht time se video search kr rha tha aj jakar sahe kam ke video mle thanks.continue your work.

@Innozant

3 жыл бұрын

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

Good explanation Sir👏🙌

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

@Innozant

3 жыл бұрын

Thanks Deenabandhu ji..❤️❤️🙏🙏🙏happy learning

Thanks sir Nice explanation

How simple you make a thing for us!!!! It looks so easy the way you explain. Thank you..

@Innozant

2 жыл бұрын

Thanks Anup..Happy Learning 🙏❤️

more i see you the more i get amazed with ur knowledge nd teaching prowess....

@Innozant

3 жыл бұрын

Thanks for such a lovely comment 🙏❤️

बहोत बहोत बढीया वर्क नया देकर खुशी पाता हे हम

@Innozant

3 жыл бұрын

Thanks Atul Ji🙏❤️

You are really great, Thanks a lot for such a wonderful content of Vlookup.

@Innozant

3 жыл бұрын

Thanks Mohit .have a great day ahead,🙏❤️

Thank you sir 🎉 this trick very use full

Respect from the bottom of my heart... 🙏🙏

@Innozant

2 жыл бұрын

Thanks dear ❤️

@CMAFreedom

2 жыл бұрын

@@Innozant mention not sir...An excel aspirant from your videos

Sir this trick is amazing

Excellent teaching

Superb sir ji

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

@Innozant

3 жыл бұрын

Thanks Chauhan sahab..God bless you dear..Happy learning.

bahut hi badiya description dia h...ur videos are really the best videos on youtube on excel...keep spreading ur knowledge ✌

@Innozant

2 жыл бұрын

Thanks Dear...God Bless you Really means a lot to me..Happy learning ❤️

great Guruji

Wah wah kya baat he

Your explanation is amazing ☺️

@Innozant

Жыл бұрын

Thanks Navya.. Really means a lot to me 👍❤️

really you are a great teacher

@Innozant

Жыл бұрын

Thanks a lot

Thanks. For help

Totally speechless amazing sir..thank you so much sir🙂🙂

@Innozant

Жыл бұрын

Thanks Nisha..God bless u ❤️👍

Thanks great learning

Thank you bhai

Thanks... today I used this trick..Superbbbbb

@Innozant

3 жыл бұрын

Veey Good 👍👍🙏❤️

Thank you sir

very great sir

Excellent sir, your talent deserve,at least 1 lakh subscriber.

@Innozant

4 жыл бұрын

Thanks Jaspal Rana Ji,I am trying my best to Deliver the contents that definetly adds value in Learners life. Thanks for wishes 😊

Great Sir... your all videos are awesome

@Innozant

2 жыл бұрын

Thanks Bhuwanta sahab♥️👍

amazing video

very helpful

Very nice sir 👌 aap vlookup bahut acchy triky se smjhaty h

@Innozant

2 жыл бұрын

Thanks Jitender Ji❤️

Excellent

Best video I have ever seen

@Innozant

10 ай бұрын

Thanks dear

Thank you; learned a lot

@Innozant

3 жыл бұрын

Thanks Sujit Ji🙏❤️

So many thanks sir this video class solve my problem विच I have asking today in comment box your other vlookup class

@Innozant

2 жыл бұрын

Great Rajeev ji👍

nice explanation sir. keep it up. thank you

@Innozant

3 жыл бұрын

Thanks Satish Ji.Happy learning

V.Good...😊

Thnx

Thank you it really helped

@Innozant

3 жыл бұрын

Thanks Santosh ji🙏❤️

Sir✌️❤️

Thank you so much.

@Innozant

3 жыл бұрын

Thanks Dheeraj Ji

thank you baiya

@Innozant

2 жыл бұрын

Thanks dear❤️👍

Super very helpful thanks

@Innozant

3 жыл бұрын

Thanks Mohan

@MohanKumar-uk1gj

3 жыл бұрын

@@Innozant sir I want to know which position of u in text KZread mujhe tube se Jo 'U'hai use position chahiye pelha 'U' Jo hai you is me nahi to yen kaise kiya jaye pls explain

very imprssives video sir.

@Innozant

2 жыл бұрын

Thanks

👏

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

@Innozant

2 жыл бұрын

Ok Wasim..will add your request in upcoming vidoes

Hi. Can we use 2 lookup values in vlookup fuction where one lookup value is date and another is text

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 ?

oooo sir you are jhaka naka 😚

Sir agar condition slab mein ho agar 1-25, 25-50, 50-75...............?

Sir isko hum DGET function se kare toh koi issue toh nahi hoga

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

Can we do it without helper column, kindly suggest

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.??

Nice trick 🙂🙂

@Innozant

3 жыл бұрын

Thanks .Hv a nice day🙏🙂

Mujhe mera solution mil gya😄😄😄🤪

@Innozant

2 жыл бұрын

Thats great Arun👍❤️

sir can we use DSUM method here ?

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

Nice

@Innozant

2 жыл бұрын

❤️

Sir, Can you suggest me any way to use lookup function when the lookup value is in a merged cell?

@Innozant

2 жыл бұрын

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.

Thanks for explaining, is it possible to solve without using helper column.

@Innozant

3 жыл бұрын

Yes it is possible..will surely upload video for the same

nice

@Innozant

3 жыл бұрын

Thanks Dear 🙏♥️

🌟🌟🌟🌟🌟

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

👌👌👌👌👌👌👌👌👌

@Innozant

3 жыл бұрын

Good Morning..Thanks Nisha ji,Happy learning❤🙏

Please help 2 values ki bicha values ko ek column m kese find karenge

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

@Innozant

3 жыл бұрын

Share your sheet @innozantofficial telegram id.Will see

Sir how to do same when other column is DATE colum?

SIR SAME PROCESS GIVES ERROR WHEN WE TRY TO PULL DATA IN SHEET 2 FROM SHEET 1

How can use vlookup with 2 lookup values without using helper coulmn and return single value?

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

@Innozant

2 жыл бұрын

Using vlookup even we can do the same..why there is need of XLookup or filter Kavita ji

@kavita8390

2 жыл бұрын

How do we do using vlook up ?

Sir how do you add that helper column to the table???

@farhatparveen2594

11 ай бұрын

By using formula =B4&"l"&KARTIK

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

all formulas advance excel uplood korun .

like banta hai

Suoerb

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 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

Sir kya hm esse index or match se kr skte hai?

@Innozant

3 жыл бұрын

Kisi bhi function se kiyabja sktabh solution dear

Koi other method hey for same result??

Same roll no(Same ROLL NO.) do Alag alag students ke kaise ho sakte hain??

Sir esko agar index se krna hoga to kaise kre maine bohot try kia but nhi ho raha

Sir i want to solve this without helper pls suggest

Sir without helping column kse karenge

I did it by using concatenate function.... =VLOOKUP(CONCATENATE(B13,C13),$A$4:$D$9,4,FALSE)

@Innozant

3 жыл бұрын

very good dear

Odd even number per row and coulam ka use kaise kare

Without helper column i use vlookup +choose advance App se hi sikha hai sir je advance unique formulas lagane hahaha

@Innozant

3 жыл бұрын

👍👍

Can we do it without using Helper column

@Innozant

Жыл бұрын

Yes we can

Sir i need your help in excel can you help me

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 mujhe nested vlookup sikhna he

@Innozant

3 жыл бұрын

Double vlookup ke video dekhiye..Lookup & Reference playlist se❤️🙂