Which Lookup Function?

[droy1215]

Forgive me if this is a simple solution. My background is more in Access than Excel.

What I have are a series of tables like the copy-paste below. All of these tables are held on one sheet. On another sheet, I want to display the maximum within a row, based on the date. In a second cell, I want to display the column name of that maximum.

Any help would be appreciated. Thank you.

Week Number End Date Me Shel GSB PICA JR. VEDA GTV HERN IWIN
4/5/2015 0 0 0 0 0 0 2 0 0
1 4/12/2015 39 41 31 42 38 50 31 39 25
2 4/19/2015
3 4/26/2015
4 5/3/2015
5 5/10/2015
6 5/17/2015
7 5/24/2015
8 5/31/2015
9 6/7/2015
10 6/14/2015
11 6/21/2015
12 6/28/2015

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.