how would i wrtie this formula
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 |
how would i wrtie this formula
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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "GMAN2004" wrote in message ... 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 |
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 |
All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com