HOW TO USE VLOOKUP FUNCTION WITH MULTIPLE CRITERIA IN MS EXCEL (TAMIL) | Kallanai YT

In This Channel I'm Providing Advanced MS Excel & VBA Macro Tutorials In Tamil Language etc.....
Also I Solved Rubik's Cubes & Praminx Cubes In Tamil (From 2x2, 3x3, 4x4 & 5x5)
HOW TO USE VLOOKUP FUNCTION WITH MULTIPLE CRITERIA IN MS EXCEL (TAMIL) | Kallanai YT

[@ganeshmanchi8499]

Hi, I happened to view this video and its really a jaw-dropping scenarios... I like your statement that we should be more creative in arriving at the formulas using different functions... My learnings out of this was (1) Helper; (2) the Pipe Symbol; (3) Choose; (4) F9 for interpreting the 1 & 2.. very good indeed...

[@KallanaiYT]

Thanks alot for ur continuous support

[@perumalk8627]

Hi sir I am having a single Excel workbook that file having min. 5 no of sheets each sheets having some different data (i.e part price,no of parts, received date etc.,) Like that file is master file
In another Excel file how can I getting value for same time from that 5 sheets (master file)
How we can make vlookup formula for this case (single formula with vlookup formula) please help me 🙏🏻🙏🏻🙏🏻🙏🏻

[@dhivyad7556]

Bro this concept okk... But 100000 ku mela data iruntha.... Intha concept romba delay aguthu bro.... Athu epdi work pandrathu...

[@KallanaiYT]

Which excel version u r using ?

[@dhivyad7556]

2010 bro

[@KallanaiYT]

It's depends upon system configuration. If u r using high configuration system then system will react fast

[@arulg5837]

sir how to insert pipe symbol