help needed

[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...

 

[BenjieLop]

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.

 

[todd22]

it works..great thanks!!

 

[BenjieLop]

Thank you for the feeback.


Regards.