Insanely Useful Lookup Tricks in Excel

[@GoodlyChandeep]

Download the Excel file - goodly.co.in/insanely-useful-lookup-tricks-in-excel Join my weekly newsletter - goodly.co.in/subscribe/ More Excel Tricks - kzbin.info/www/bejne/oGalgaOZmrBqi7Msi=tqvZ8e-cathsMdit

[@The_Kite_Makers]

This man never fails to impress. Good job pal

[@ExcelWithChris]

Love the "looking to left" version of vlookup.

[@pondyanand]

As usual, you spring a surprise everytime !! Left lookup is just amazing !

[@MoonShine-bs6cl]

Awesome learning from you always.

[@Sumanth1601]

@10:35 Bam ! This is what I was looking for, Brilliant as always..Great tip.

[@dipanjankajuri3600]

Multiple results ia great!

[@McKaySavage]

Great tricks! I’ve never tried the fuzzy matching plugin before. I’m curious though why you didn’t use FILTER() for #4 as a replacement for the IF-TEXTJOIN-SPLIT combo you built? If you want to lookup all values that meets a criteria, isn’t that what filter is for?

[@zuzanasmekalova4632]

yes, exactly, filter is much better for that. And jointext + split text can be easily avoided with simple use of TRANSPOSE function.

[@Amamialoo]

Great tips here again! Hey, I'm quoted ! 😅 Your courses are really valuable. I recommend.

[@stephanddd]

Gold! Thank you

[@vanistajames346]

Your video has made a real impact. Thank you❤

[@juja2819]

Great video :) Thanks!

[@unnikrishnansanthosh]

excellent, thank you for sharing

[@arbazahmad7177]

Excellent...thanks for sharing 🎉

[@thedebapriyakar]

This is absolutely crazy 😧

[@eslamfahmy87]

Good job

[@RichardJones73]

Addins not available in my workplace but great video as always

[@muhammadasad729]

Can we have a single-cell dynamic formula for multiple IF LOOKUP instead of duplicating it down @ 9:33? The need is to use it within a model. Maybe we can use a BYROW.

[@SHS-8]

I like using xlookup but does it use more ram to run the function? coz I face my xl is taking more time to calc xlookup than using the vlookup.. And the IF function lookup is dope! Thanks for the video!

[@GoodlyChandeep]

Try fast vlookup trick - kzbin.info/www/bejne/pV6XqX6OqJusZqc

[@SHS-8]

@GoodlyChandeep wow! You really magician! Thanks for that work around. I will use this with xlookup.. thanks

[@manojkahar5718]

Hi Chandu, Nice video, The if condition trick was awesome. can we do the same in M Language.

[@GoodlyChandeep]

I have a power query grouping video on that already

[@khalidalisubhanallah2947]

very knowledgeable video sir, but my quistion for example F2 say lay kar F650 tak cell main mukhtalif amount likhi hay agar f2 say lay kar f650 main say kisi cell say 1 bhi digit kam ho to cell automatic color ho ja.

[@ernstborgener3745]

Tip 4 does not work in Excel 2021 because the TEXTSPLIT function is missing. Instead, the following shorter formula can be used. =TRANSPOSE (UNIQUE((FILTER(C$3:$C$14;$B$3:$B$14=E3))))

[@mmgtuneindia7925]

Thanks for great video. In the final example of commission what happens if the commissions are on sliding scales meaning for $96 sales the commission needs to be calculated as First $25 x 5% + $44 x 7%+24x10% etc. Is there a way to wrap that into one formula?

[@priyeshsanghvi8424]

You may add a constant value from the previous slabs along with the current slab-related %.....Eg for 7% slab, it would be $ 1.25+7%, for 10%, it would be ($ 1.25+$ 3.08)+10%, etc.

[@bugsdenis547]

For the 4th trick with TextSplit and TextJoin, why not a Transpose instead ? for the If, why not a Filter ?

[@teoxengineer]

And, If I didn't use O365 and used regular excel, how can I use Vlookup with unadjusted data instead of ChooseCol function? Besides, how can we find last value in a range by using Lookup?

[@Hussain_1990]

Instead of IF formula, you could use FILTER formula. Much easier.

[@Bhavik_Khatri]

Although fuzzy lookup is a valuable tool, its implementation necessitates additional installation procedures. Conversely, Power Query provides a more streamlined and user-friendly approach. Developing solutions within an organisation becomes more challenging unless individuals have access to the most recent and advanced add-in. Notably, Power Query remains an underutilised feature in Excel for many users.

[@14uniq]

Request to add Rupay card or UPI also to purchase option.

[@GoodlyChandeep]

can send an email to [e-mail] I'll send you an alternative UPI payment method.

[@emilmubarakshin49]

If is beat trick

[@MervinRamos]

@GoodlyChandeep How to ungroup if you have this data table with column header "Date/Time" it was stack like this Date/Time Status. NAME Oct2 7:00 AM. Entry JAMES 8:00PM. Entry JOHN 9:20 PM. Exit JOHN Oct4 6:00 AM. Entry 8:20 Am 10:30 PM 12:10 PM Oct5 2:00 PM Oct9 1:00 AM 3:20 AM Somthing like that wanted to summarize it by date in power query