Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup with merged cells
I have thouands of rows of data with part numbers for items. In the columns
for that part number there are multiple rows of data. What configuration of a lookup can I use to pull my data out with the merged cells? I've tried unmerging a few to try using vlookup, but it will only return the first value found. It won't grab the rest of the data. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup with merged cells
=vlookup() only retrieves the value on the row of the first match.
Chip Pearson has some notes on how to bring back an arbitrary match: http://www.cpearson.com/Excel/TablesAndLookups.aspx Ryan wrote: I have thouands of rows of data with part numbers for items. In the columns for that part number there are multiple rows of data. What configuration of a lookup can I use to pull my data out with the merged cells? I've tried unmerging a few to try using vlookup, but it will only return the first value found. It won't grab the rest of the data. Please help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Using Vlookup with merged cells... | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
VLOOKUP across merged cells | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |