LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Link
 
Posts: n/a
Default Finding a Value in First Column of Table with VLOOKUP?


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY Scott Lolmaugh Excel Worksheet Functions 3 March 9th 06 11:05 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Pivot Table (vlookup 2 column text values, return 1 value) Al Excel Discussion (Misc queries) 1 November 30th 05 01:15 AM
Vlookup - name of file to get info from is in Column A DD1 Excel Discussion (Misc queries) 3 August 11th 05 06:55 AM
Finding intersection of row and column (both variable) in table RangerAl Excel Worksheet Functions 8 January 1st 05 01:28 AM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"