| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
I put together a little sample file that demonstrates this.
Send me an email: xl can help at comcast period net Remove "can" and change the obvious. This requires an array formula and you can't enter array formulas in merged cells. Merged cells really don't do anything but cause problems! Biff "fastballfreddy" <fastballfreddy.27ml3a_1147321202.2769@excelforu m-nospam.com wrote in message news:fastballfreddy.27ml3a_1147321202.2769@excelfo rum-nospam.com... Ok, I can undo the merged cells, but what would I use for a formula? Let's just say the names are in A1-A10, the #s in B1-B10. What formula would you use in C1? thanks -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple column match per row | Excel Discussion (Misc queries) | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| match multiple criteria and highlight corresponding row in Excel | Excel Worksheet Functions | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Hybrid Mode
