how would i wrtie this formula

  • Thread starter Thread starter GMAN2004
  • Start date Start date
G

GMAN2004

in my workbook

on sheet 1, i have this infor

column A column B
mike 20
frank 10
billy 5

on sheet 2

column A column b column c colimn d
billy ? frank
?

the information in cloumn b on sheet 1 will change each week
i would like for excell to look at billy on sheet 2 column A find it on
sheet 1 column A then input the information in column B on sheet 1 into the
slot next to billy on sheet 2 column B.
 
Let's say the Sheet1 stuff is in A1:B10 and on Sheet2 the word 'billy' is in
A1
In B1 of Sheet2 use =VLOOKUP(A1,Sheet1!$A$1:$B$10,2,False)
best wishes
 
I am going to assume for each sheet you describe, that the data starts in row
1.
On sheet 2, row 1 column B (also B1) type:

=LOOKUP(A1,Sheet1!A1:A30,Sheet1!B1:B30)

Change the Sheet1 to match the name of the sheet, if different. Copy and
paste down column B of sheet 2. Adjust the range to match your data range.

Les
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify working code to expand the output. 5
Transfer array element offset value to a matched value 3
ERROR 400 on identical codes different range 8
Clean this select case code up a bit. 2
Copy columns and paste with blank column between 5
Array with many cells from a row but not in order or together 11
Excel formula for counting nr records with data and related empty fields 3
VBA Help 1

Back
Top