28 prompts matching "xlookup"
Act as a finance analyst. I need to reconcile two Excel sheets, {{Sheet A: e.g.,...
I need to reconcile two Excel lists that should overlap, but the data is messy. ...
Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...
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...
I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...
You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....
Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...
You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...
Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...
I need to look up values in Excel using multiple conditions. My dataset has colu...
Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...
I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...
I need to retrieve data from a lookup table in Excel. My main table has [column ...
I have two Excel sheets: my bank statement transactions and my internal accounti...
I need to compare two Excel sheets that should match but probably don't. Sheet A...
You are an Excel power user. I have two lists in Excel that are *supposed* to be...
Act as an Excel performance specialist. I will describe a workbook that has grow...
I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...
Act as a RevOps analyst. Help me design an Excel commission tracker that auto-ca...
You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...
Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...