help needed

**todd22** · 03-05-2006, 12:53 AM

hi guys need some help here:

let's say i've got a sheet with the following data:

Name Apples Oranges
John 1 3
Peter 2 2
Mike 1 0

i got another sheet with the following table:

Name Apples Oranges
John
Jane
Peter
Harry
Mike

is there a way to, for eg, sort of "tag" 1 apple and 2 oranges to john's name. then let it appear in the correct column on sheet 2?

thanks in advance...

**BenjieLop** · 03-05-2006, 02:51 AM

Originally Posted by todd22

hi guys need some help here:

let's say i've got a sheet with the following data:

Name Apples Oranges
John 1 3
Peter 2 2
Mike 1 0

i got another sheet with the following table:

Name Apples Oranges
John
Jane
Peter
Harry
Mike

is there a way to, for eg, sort of "tag" 1 apple and 2 oranges to john's name. then let it appear in the correct column on sheet 2?

thanks in advance...

ASSUME

1. that the range of your data worksheet is A2:C10
2. this data worksheet is Sheet1

In your other sheet with a table that you want to fill up, enter in Cell B2

=vlookup(A2,Sheet1!$A$2:$C$10,2,0)

and in Cell C2, enter this formula

=vlookup(A2,Sheet1!$A$2:$C$10,3,0)

Copy down your formulas in B2 and C2 until your range requirements are satisfied.

Regards.