22 prompts matching "lookup"
Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...
I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...
Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...
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...
I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...
I need to look up values in Excel using multiple conditions. My dataset has colu...
I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...
I have a messy customer address dataset (~500K rows, CSV). Issues observed: inco...
I exported a survey to Excel. Each respondent is one row, each question is its o...
Act as an Excel performance specialist. I will describe a workbook that has grow...
I am a founder. I want an Excel sheet where I paste my bank statement export int...
You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...
I need an Excel formula that assigns a grade band based on a score, with at leas...
Act as an Excel formula expert. I need to calculate sales commission using tiere...
You are an expert Excel formula engineer. Help me write and explain a single Exc...
Act as a financial modeler reviewing my workbook. I have a model that runs base/...
Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...