20 prompts matching "vlookup"
Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...
Give me a complete Excel data cleaning checklist with formulas for each step: 1)...
Act as a finance analyst. I need to reconcile two Excel sheets, {{Sheet A: e.g.,...
Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...
I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...
I have an Excel formula that is not working correctly or returning unexpected re...
Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...
Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...
You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....
I need to retrieve data from a lookup table in Excel. My main table has [column ...
Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...
Design a library of reusable custom Excel functions using the LAMBDA function fo...
Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...
I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...
I need to compare two Excel sheets that should match but probably don't. Sheet A...
I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...
You are an Excel power user. I have two lists in Excel that are *supposed* to be...
Act as an Excel formula expert. I need to calculate sales commission using tiere...
You are an Excel modeler. I'll paste two budget extracts from different teams. T...
You are an Excel reconciliation helper. I have two lists (for example, a system ...