| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and pull together
Here's an example of my spreadsheet
Column A Column B Column G Column H Column I Bob Johnson w06102 Bill Smith w06777 Hal George w05834 Jim Branigan w06723 Sales Cent. 60W06 w05834 Dee Willclef w06289 Sales East 60W06 w06777 Steve Jackson w99041 Sales West 60w06 w06163 Sanjiv Gupta w88910 Underwrite 60W08 w06102 background: I pulled the data in columns G, H and I from a seperate information source from the data in columns A and B. I pulled them into one sheet to get them on the same page. - now I want to have something that considers column B and looks to column I for a match, if it finds it, I want to pull the info from that row ( the values G,H and I for the match) and populate the data in the cells next to A and B - I want it to run down the entire column B pulling in the match and populating all the way down. Kind Regards, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Index/Match pull lookup_value from a combo box? | Excel Discussion (Misc queries) | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
Threaded Mode
