Return the Data from the last cell to the right

[azidrane]

Hey,
Let's see if I can explain this.
I have a table that looks like this

Persons Name0, (emptycell), (emptycell), (Date),
Persons Name1, (Date), (emptycell), (emptycell),
Persons Name2, (emptycell), (Date), (emptycell),
Persons Name3, (emptycell), (emptycell), (Date),
Persons Name4, (emptycell), (emptycell), (emptycell),
Persons Name5, (emptycell), (Date), (emptycell),


(I hope that makes sence)

On another sheet select Persons Name from a list. I then want to show
the very last entry on the afore stated table. IE, If i select Persons
Name5, it should return the data in cell C6 based on the fact that it
is the cell furthest on the right with data.

Make sence?

(i'm sensing an array formula here)

Cheers!

 

[vane0326]

Is Name5 is in cell A6*?* if so try this:


=LOOKUP(2,1/(1-ISBLANK($C6:$IV6)),$C6:$IV6

 

[azidrane]

I can barely make out what this means. Any Comments on the different
parts of the formula?

 

[vane0326]

I'm sorry are looking for a VLOOKUP solution*?* If so would thi
work*?*


=VLOOKUP("Name 5",Sheet3!A1:C20,3,0)

I'm really have been on this forum to much. Does this forum allows t
attach sample files*?

 

[Ardus Petus]

If there's only one date per row (all other cells empty)

Assuming the name is in B10:
=MAX(OFFSET(B11,MATCH(B10,A1:A6],0)-1,0))

HTH

 

[azidrane]

I guess my inital post was to vague.
There may be more then one date in a given row.
Also, The lookup needs to be done on an array. In this case A16
A1 obviously holds the persons name.
Then we select a name from a cell with list validation on a different
sheet. We'll call this sheet "sheet1". When we make the selection,
another cell on the sheet1 should look at the array on the other sheet
(we'll call that "sheet2").

It needs to return the last date on the right in the row that starts
with the persons name. I though a fancy vlookup would work, but I can't
figure out how.

Cheers!