| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup column headings?
Hi Folks,
I have a Spread sheet that is 1430 rows deep by 39 columns long. I have extracted from this the min value of each row into another spread sheet. Now I want to use these min values to look back at the original spread sheet and find what column the min value came from (i.e. its heading) Ive tried many machinations of hlookups, index, match but I cant seem to get the thing to work, Cheers in advance, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
