VLOOKUP Formula to pull column data into another sheet

jwilson

I'm trying to match the "Application" # (Table 1) to the "Application Name" (Table 2) and return the corresponding "Primary Product Family" (Table 2, Column 2) into "Program" (Table 1, Column 1) using the VLOOKUP formula, but I'm receiving some of the information and the other information returns #NO MATCH.

I want to match the "Application" in Table 1 and "Application Name" (Column 1) in Table 2, then return the "Primary Product Family" (column 2) into "Program" in Table 1.

Table 1: Formula is in Program.

Table 2: matching the Application Name, then pulling from Primary Product Family column

=VLOOKUP(Application@row, {Applications}, 2, false)

What am I doing wrong here?

Gillian C

Hi @jwilson

Have you tried using INDEX MATCH instead? If I'm trying to pull particular information from another sheet I use INDEX MATCH (if you want to pull a valued based on 1 set of criteria) or INDEX COLLECT (if you want to pull a value with multiple criteria to match).

Try

=INDEX({Primary Product Family}, MATCH(Application@row, {Application Name}, 0))

Using the 'Reference another sheet' for the Primary Product Family and Application Name ranges.