Thread: output to another sheet

I am farely new at Excel trying to get all of this.
I have 2 worksheet

On worksheet 1 I have names in columne A1 and numbers in A2

On worksheet 2 I would like to output information as follows

if worksheet 2 colomne A1 has the name that is on worksheet 1 colomne A1 output information in worksheet 1 colomne A2 to worksheet 2 colomne A2

I can get it to work with the =IF function but my list is 50 names long I don't know how to do it that it will match any name on worksheet 1 and output the numbers on workssheet 2

example of worksheet one
A1 B1
user1 50
user2 10
user5 30

on worksheet 2 I would like

A1 B1
User5 would like it to find in worksheet 1 and output 30

AHH i'm loosing myself just trying to explain it I hope someone understands what I am trying to do.

THank you for your time

Originally Posted by chant

I am farely new at Excel trying to get all of this.
I have 2 worksheet

On worksheet 1 I have names in columne A1 and numbers in A2

On worksheet 2 I would like to output information as follows

if worksheet 2 colomne A1 has the name that is on worksheet 1 colomne A1 output information in worksheet 1 colomne A2 to worksheet 2 colomne A2

I can get it to work with the =IF function but my list is 50 names long I don't know how to do it that it will match any name on worksheet 1 and output the numbers on workssheet 2

example of worksheet one
A1 B1
user1 50
user2 10
user5 30

on worksheet 2 I would like

A1 B1
User5 would like it to find in worksheet 1 and output 30

AHH i'm loosing myself just trying to explain it I hope someone understands what I am trying to do.

THank you for your time

Hi, just use a straightforward VLOOKUP() function in B1. i.e.

=VLOOKUP(A1,Sheet1!A:B,2,False)

Rgds

Thank you very much you made my life so simple now