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.
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 | |||
| 8 | |||
| 9 |
Find the source record for F2
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
- —