WORK 83 words
Decide Which Lookup Formula Actually Fits Your Data
<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.