Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
wrtie a macro to delete certain rows | Excel Discussion (Misc queries) | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |