Excel 2007 : Using excel to return value to the left.

Try this:

=INDEX(Anthony!$J$4:$J$7, MATCH(B4, Anthony!$K$4:$K$7, 0))



If you want to tie these formulas to the sheet matching the name you entered into A2, you could use this:

B4: =MAX(INDIRECT("'" & $A$2 & "'!K4:K7"))
B3: =INDEX(INDIRECT("'" & $A$2 & "'!J4:J7"), MATCH(B$4, INDIRECT("'" & $A$2 & "'!K4:K7"), 0))