INDEX/MATCH Array within LARGE Function?

I have been searching everywhere for something that might help me with this and I just cant seem to find it! I guess essentially I am trying to do a look up based on a column and then find the largest value from the row to the right of the data. It would look something like this,

Data Sheet
A 10 15 20 30
B 8 16 32 64
C 1 2 3 4
D 2 4 6 8
E 20 40 60 80


Main Sheet
Largest Value
A 30
B 64
C 4
D 8
E 80

The problem is I can make A,B,C,etc. static on my Main Sheet however since I am pulling data into the data sheet there is not always data for A,B,C,D,E which causes them to shift making it where I can just do a standard =Large(B1:B4,1).

I've tried INDEX, MATCH, ROW and some other ideas but cant get anything to work!!!

Any ideas? Thanks!

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Try this...

Data Range

	A	B	C	D	E
1
2	A	10	15	20	30
3	B	8	16	32	64
4	C	1	2	3	4
5	D	2	4	6	8
6	E	20	40	60	80
7	------	------	------	------	------
8
9
10	A	30
11	B	64
12	C	4
13	D	8
14	E	80

This formula entered in B10 and copied down:

=MAX(INDEX(B$2:E$6,MATCH(A10,A$2:A$6,0),0))

You're welcome. Thanks for the feedback!