MS Excel - Lookup Full Record

MS Excel - Lookup Full Record
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[GayashanWanniArachchi]

Thank u Very Much sir..ur all lesson help to improve my excel knowledge.

[saubhagyaswain]

Yes, even I had the below question in the mind that when we can do the same work with LOOKUP function? Even I tried doing so with both of the formulae of LOOKUP function and it works absolutely fine.
Maybe, he is just introducing us with another method. But as of now if we can do this work with a short formula of LOOKUP then there is no requirement for MATCH function.


It would be great if any excel master can answer this doubt for Pankaj SIr himself can clarify this doubt.

[nandinisharma]

Sir, why there is need of match function when we can do the same work with the LOOKUP function?

[rajat]

When the no. of the column is very large then we can't say its position number. In that case, the match function comes to rescue.

[themessi]

Can we get the answer on 0:37 using the lookup function as you taught in the previous video?

[nikunjkumar]

U can also use xlookup for this function

[shamseerp]

why there is need of match function when we can do the same work with the LOOKUP function?

[bsurendar]

But this formula works only in one row and you cannot drag the formula to all rows. please try the same example as in video, in 17th row just put as camera and if you drag the formula it wont work

[priyankabulbul]

Sir, what is the difference between lookup full record & Vlookup full record with match function ???

[MaheshKumar-kkcj]

What is different between vlookup and match funtion

[yashikagehani]

when I'm pressing f4 its opening sceen cast dialogue box instead of fixing The cell please help how to do it

[sujil]

if there is one more row how to change the formula?

[pranjuu]

I think we can use lookup formula here am I correct?

[HassanMushtaq.]

sir last video mai bhi hmnay yahi kam kia tha

[ashvinpatel]

I WANT FORMULA FOR CALCULATION OF INSURANCE AGR WISE AND SUM INSURANCE

[pratyushkumarbarik]

Hi, could you please share the exercise file of this?

[vish]

Why 0 was added again at the end?? Thnks

[subratkundu]

can't I do this using lookup function?

[devbhumi]

Sir mene ye try kiya bt answer not match 😔