Skip to main content

Choose wildcard searches or literal product codes

Your goal: Compare intentional pattern matching with literal identifiers, returning the first physical source record and preserving numeric zero.

Full 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.

Pattern versus literal, first duplicate and zeroFind the source record for F20 cells selected
Lookup text · F2: "A*"Interpretation · G2: "Pattern"
Tap identifier or key cells for this decision Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
8
9
Step 1 of 6

Find the source record for F2

Select the matching value or key cells in the worksheet, then check your choice.

Rules for this step

Use the stated Pattern interpretation: * matches any sequence, ? one character, and ~ escapes the next character. Choose the first physical matching record.

Lookup text · F2
"A*"
Interpretation · G2
"Pattern"

Your selected source cells will appear here.

Position inside the lookup array
—
Price
—
Units
—
Product code
—
0 cells selected