| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match data to another sheet and return all the data on that row
Help Please!
I have worksheet1 with a name in cell D2, worksheet2 has a varity of names in column H. If the name in D2 in located in sheet 2 column H, I'd like for all the infoamtion in that row to be copied back to sheet1. Is this possible? I've tried different formulas, but am just not getting. Can anyone please provide some help?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match data to another sheet and return all the data on that row
=INDEX(Sheet2!A:A,MATCH($D$2,Sheet2!$H:$H,0))
=INDEX(Sheet2!B:B,MATCH($D$2,Sheet2!$H:$H,0)) etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bbrant2" wrote in message ... Help Please! I have worksheet1 with a name in cell D2, worksheet2 has a varity of names in column H. If the name in D2 in located in sheet 2 column H, I'd like for all the infoamtion in that row to be copied back to sheet1. Is this possible? I've tried different formulas, but am just not getting. Can anyone please provide some help?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
| LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
| Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
| Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
Hybrid Mode
