Compare

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I got 4 columns as below in which Name:Age has a relation. In the Name2
column, I got a subset of Name1 column, I need the Age2 column to be filled
by looking up the Name1:Age1 relation.

Name1 | Age1 | Name2 | Age2
 
Hi Joe

Check out help on VLOOKUP()

In cell D1
=VLOOKUP(C1,A:B,2,0)

This returns an error if the entry in C1 is not in ColA. You can handle that
using
ISNA() IF() combination as below.

=IF(ISNA(VLOOKUP(C1,A:B,2,0)),"",VLOOKUP(C1,A:B,2,0))
 
Back
Top