Look up a value within multiple columns and return the value in the far left (or right) Column

[larrster1]

This is my problem now:
I am using Office 2003
I am trying to use a formula (Maybe a VLOOKUP not sure if it's the best choice) so when a name is entered on the 'Sign Up Sheet' it returns a date that corresponds to where the name was entered and returns the date in the first column of the 'Sign Up Sheet'.


An easier example of what I want to do is if you have football squares and you enter your name in a cell (one of the squares) on a spread sheet it returns the value of the corresponding number in that row from the far left column (Could return value from the right column as in a Vlookup formula if needed) in a different worksheet. Ideally I would love to also have it identify the top scores too. So in other words if I put my name in the middle of the random boxes (Squares/Cells) the other worksheet will show me my two numbers. The number at the top of the column I am in and the number to the left of the row I am in. This would be so cool for what I am doing as well as a cool formula for all future Football Squares Pools.

Hope that all makes sense.


Larry Cochran

 

[venkat1926]

more helpful if the small extract of sheets posted and explained with reference to that data.
in vlookup formula the lookup value (ref value) should be in the first colmn and what you need in the 2nd,3 rd etc columns.
but if you need to the left of vlookup value then use index match function

 

[larrster1]

Thanks for the reply!
Tried some Index and Match combos but still no luck... Anyone?

 

[mikerickson]

Perhaps a CSE formula like

=INDEX(A:A, MAX((A1:G20="cat")*ROW(A1:G20)), 1)

entered with Ctrl-Shift-Enter (Cmd+Return for Mac)