how would i wrtie this formula
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
"GMAN2004" wrote:
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.
--
MIKE HOLDER
|