Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I have many tables which look roughly like the following (Row and Column numbers are also shown): B C D E F 21 Sunday 10 25 6 96 22 Monday 21 32 9 12 23 Tuesday 5 1 12 0.001 24 Wednesday 47 1 63 41 25 Thursday 1 8 0.5 7 26 Friday 6 55 11 58 27 Saturday 8 62 32 12 Only the numerical values change in all the tables. I need a formula that will identify the highest numerical value (which is 96 here) and return the day of the week from column 1 in which it falls (here, Sunday). I've been trying to use VLOOKUP in conjunction with MAX, but I'm clearly screwing that up because I keep getting an interesting array of error messages. Does anyone have any ideas? VLOOKUP seems designed to do the opposite of what I want, since I want to always find the value in the first column that corresponds to a value inside the table. Is there a better way to go? Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
Vlookup - name of file to get info from is in Column A | Excel Discussion (Misc queries) | |||
Finding intersection of row and column (both variable) in table | Excel Worksheet Functions |