| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array formula combined with Lookup
I have this which works.... {=MIN(IF((list!$C$3:$C$7202=B4),list!I3:I7202))} This formala returns the value in column I (the minimum value that meets the criteria), however once I find the minimum, I would also like to know the values in the other columns within the same row (e.g. other information about the row entry). How can I find other infomation in the same row as the value I am finding with the array formala above. All help woudl be very much appreciated -- Kevin Gallagher ------------------------------------------------------------------------ Kevin Gallagher's Profile: http://www.excelforum.com/member.php...fo&userid=7459 View this thread: http://www.excelforum.com/showthread...hreadid=518104 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
| Lookup Array Formula | Excel Worksheet Functions | |||
| I need to create an array formula combined with a countif | Excel Worksheet Functions | |||
| How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Threaded Mode
