Do a Two Way Lookup in Excel - Match() Index() Functions
Loading...
Loading...
3:02
Remove the #N/A Error from VLOOKUP in Excelby ExcelisHell24,193 views- 8:39
HLOOKUP() in Excel - how to use it and edit it. Walkthrough explanation.by ExcelisHell70,924 views
- 9:57
Match() and Index() Functions in Excel - Thorough Explanationby ExcelisHell15,234 views
- 6:59
Make a Dynamically Updated Vlookup Table in Microsoft Excelby ExcelisHell18,131 views
- 6:45
Linking Data from Different Excel Sheets and Workbooksby ExcelFormulas19,493 views
- 6:23
VLOOKUP Between Separate Workbooks and Worksheets in Excelby ExcelisHell88,833 views
- 4:07
SUMIF and COUNTIF functions in Excelby AuditExcel28,892 views
- 1:09:39
Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)by ExcelIsFun19,387 views
- 7:01
Excel: Drop-Downs(Combo Box) and Conditional Formatting (Voice Tutorial)by iProRyan35,554 views
- 6:06
Stop entering data manually and start using Excel's VLookupby DannyRocksExcels7,651 views
- 5:52
Dynamically Update a Drop Down Menu/List - Data Validation & OFFSET() Functionby ExcelisHell59,428 views
- 6:33
Create pivot tables in Excelby bytebodger75,527 views
- 3:17
Merging (Joining) two worksheets based on common column values using ActiveData For Excelby ActiveDataForExcel22,426 views
- 6:59
Excel Lookup Series #7: LOOKUP Functionby ExcelIsFun35,430 views
- 6:28
How to Merge Multiple Excel Workbooks to a Master Budgetby DannyRocksExcels41,052 views
- 7:34
Excel Magic Trick 606: INDEX & MATCH Two Lookup Valuesby ExcelIsFun15,031 views
- 4:56
Excel Lookup Series #12: INDEX & MATCH functions Example 2!by ExcelIsFun42,389 views
- 4:18
Many VLOOKUP Columns - 1123 - Learn Excel from MrExcelby bjele12311,741 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun35,062 views
Do you have a video that teaches how to created a formula that uses one or the other? Let's day you have two criteria to extract data, Name of person or ID number. Thanks.
chowman007 2 months ago
Thanks
ochienw 4 months ago
Hi EIH, am getting my feets wet with the match function and I welcome your input on how I can return certain data that meets a criteria. example: I have assigned a # to identify an employee. this employee has a preference to work an area. As I input the list of employees I want the formula to transfer the data of "only" those employees who work a specific area, creating a list for that particular area as I input the data in the main page. Can this function help me?
chowman007 8 months ago
This has helped me so much! i ow you like 30 hours of my time lol! thank you for posting this! My boss is gona be well impressed hahaa! Many thanks mate
stupot008 8 months ago
You saved me from nightmare! You should have become IT teacher in our school since my IT teacher is piece of S! Anyway, -well explained and bye!
83631171 10 months ago
thanks
83631171 10 months ago
Thank you so much! You solved my excel problem pretty quickly - well explained :) Ta
spudster06 1 year ago
Awesome...right on point and helped me solve the challenge in more elegant way than concatenating and adding extra columns etc. THANKS!
srananlobi 1 year ago
SO MUCH BIG WORDS!!!
MsFirday 2 years ago
Point the lookup functions to the drop down menus and that should work.
ExcelisHell 2 years ago