Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull Data from one sheet to another
This should be a pretty easy formula but I can't figure it out. Will someone
please help? In SQL I'd say GET SS# from Sheet1 where NAME EQ Sheet2!A1. In other words on sheet2 I have names in column A. I also have this person's name in Sheet1 along with other personal information (names on different columns). In column B of sheet2 I need a formula that compares the name in sheet2!A1 to the names (columnC) of Sheet1 and pulls the SS# of that person's record/row. In order to make sure that it's the right person (there could be 4 jim smiths for instace) it would also need to depend upon a blank in column G. (The list is generated from names in sheet1 with blanks in column G. If G has data, the row is ignored.) So to recap, I need a formula that compares the name in sheet2 to sheet1 and pulls the SS# from column D in sheet1 where the cell in row G is blank. Any takers? Thanks millions in advance. --Dax |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull Data from one sheet to another
Where are the SS#s?
Assume they're in column H. Array entered** : =INDEX(Sheet1!H2:H10,MATCH(1,(Sheet1!C2:C10=A1)*(S heet1!G2:G10=""),0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Dax Arroway" wrote in message ... This should be a pretty easy formula but I can't figure it out. Will someone please help? In SQL I'd say GET SS# from Sheet1 where NAME EQ Sheet2!A1. In other words on sheet2 I have names in column A. I also have this person's name in Sheet1 along with other personal information (names on different columns). In column B of sheet2 I need a formula that compares the name in sheet2!A1 to the names (columnC) of Sheet1 and pulls the SS# of that person's record/row. In order to make sure that it's the right person (there could be 4 jim smiths for instace) it would also need to depend upon a blank in column G. (The list is generated from names in sheet1 with blanks in column G. If G has data, the row is ignored.) So to recap, I need a formula that compares the name in sheet2 to sheet1 and pulls the SS# from column D in sheet1 where the cell in row G is blank. Any takers? Thanks millions in advance. --Dax |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a formula on wk sheet 2 to pull data from wk sheet 1 | Excel Discussion (Misc queries) | |||
VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
Pull data from multiple sheet | Excel Worksheet Functions | |||
How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |