Choose wildcard searches or literal product codes
Fill H2:J7 from the eight-row A2:C9 source. Each request has lookup text in F and an interpretation in G: Pattern uses legacy VLOOKUP wildcard syntax; Literal searches the complete stored identifier, including *, ? and ~. Matching ignores ASCII letter case, keeps other characters and leading zeroes, and selects the first physical matching row. H returns Price, I returns Units and J the actual matched product code. A missing request returns No match in all three cells. Use VLOOKUP with an explicit fourth argument for exact/wildcard lookup; approximate lookup is a separate sorted-source task. All identifiers and requests are nonempty ASCII text up to 40 characters; prices/units are finite stored numbers within ±1,000,000. Copy within each result column, keeping the source fixed.
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
Fill H2:J7 from the eight-row A2:C9 source. Each request has lookup text in F and an interpretation in G: Pattern uses legacy VLOOKUP wildcard syntax; Literal searches the complete stored identifier, including *, ? and ~. Matching ignores ASCII letter case, keeps other characters and leading zeroes, and selects the first physical matching row. H returns Price, I returns Units and J the actual matched product code. A missing request returns No match in all three cells. Use VLOOKUP with an explicit fourth argument for exact/wildcard lookup; approximate lookup is a separate sorted-source task. All identifiers and requests are nonempty ASCII text up to 40 characters; prices/units are finite stored numbers within ±1,000,000. Copy within each result column, keeping the source fixed.
No account. No upload. Just try it.