Compare

's Computer Specifications

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
-------------------------------
--
Failing to plan is planning to fail

's Computer Specifications

Try

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

--

HTH

Bob

"Joe" <(E-Mail Removed)> wrote in message
news:4AC31C48-8A87-4006-97A6-(E-Mail Removed)...
>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
> -------------------------------
> --
> Failing to plan is planning to fail

's Computer Specifications

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

--
Jacob (MVP - Excel)

"Joe" wrote:

> 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
> -------------------------------
> --
> Failing to plan is planning to fail

's Computer Specifications

It worked. Thanks Jac
--
Failing to plan is planning to fail

"Jacob Skaria" wrote:

> 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))
>
> --
> Jacob (MVP - Excel)
>
>
> "Joe" wrote:
>
> > 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
> > -------------------------------
> > --
> > Failing to plan is planning to fail

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare sheet utility that can compare formula too	Adam2046	Microsoft Excel Discussion	3	27th Apr 2010 09:26 AM
How do I compare cells and if FALSE compare to next cell in EXCEL	=?Utf-8?B?Q2luZGll?=	Microsoft Excel Worksheet Functions	0	24th Mar 2006 05:29 PM
String compare doesn't compare?	Ken Soenen	Microsoft Excel Programming	1	16th Jan 2006 03:40 PM
compare data from one column with another and compare result to yet another	Matt Williamson	Microsoft Excel Programming	1	25th Sep 2003 08:54 PM
compare data from one column with another and compare result to yet another	Matt Williamson	Microsoft Excel Worksheet Functions	1	25th Sep 2003 08:54 PM