Return three fields for a batch of lookup queries
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.