Compare

[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

 

[Bob Phillips]

Try

=IF(ISNA(VLOOKUP(C2,A:B,2,FALSE)),"",VLOOKUP(C2,A:B,2,FALSE))

 

[Jacob Skaria]

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))

 

[Joe]

It worked. Thanks Jac