WORK 83 words
Decide Which Lookup Formula Actually Fits Your Data
You know all three exist, you're not sure which one this particular lookup actually needs, and you don't have time to relearn spreadsheet functions today. This looks at your data layout and hands you the right formula, written out with placeholder references, ready to drop in.
<context> You need to look up a value in a spreadsheet and aren't sure which formula fits your data. </context> <task> **Decide** between VLOOKUP, INDEX and MATCH, and XLOOKUP for [describe your data layout and what you're looking up, including whether the lookup column is leftmost]. Recommend one, with the actual formula written out. </task> <output_format> The recommended formula name, the formula itself with placeholder cell references, and one sentence on why the other two would be worse fits here. </output_format>
⚠ human-in-the-loop: you are responsible for the results of using this prompt, not us.