Return three fields for a batch of lookup queries
Your goal: Look up four requested keys in order, preserve repeated requests and return the first exact record with an explicit missing policy.
Full task requirements
Enter one formula in G5. For each of the four query keys F2:F5, return Team, Price and Stock from the six source records A2:D7. Keep query order and repeated requests. Match full literal text without case distinction; * and ? are literal characters, not patterns. If several source keys match, use the first physical row. If a query has no match, return Not found in each of its three output cells. Retain numeric zero and signed values. All keys and teams are nonempty ASCII text up to 40 characters; Price and Stock are finite numbers within ±1,000,000.
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 |
Find the source record for F2
Rules for this step
Match the full literal identifier without letter case. Preserve *, ?, ~, spaces and leading zeroes. Choose the first physical matching record; zero is a found value.
- Lookup text · F2
- "A*"
Your selected source cells will appear here.
- Position inside the lookup array
- —
- Team
- —
- Price
- —
- Stock
- —