VLOOKUP, last cell in row. Dynamic column

[pmsrefugee]

I'm trying to find the value in the last cell of a row using VLOOKUP to determine the range (row). I don't know the column offset VLOOKUP needs to find the column as it is dynamic. It is a status report where each update is added to the row's next column. I need to get the result from the last column in the row where VLOOKUP finds the matching number. The attached file should help.

 

[Asheesh]

@pmsrefugee

Try in B1 - VLOOKUP(A1,$H1:$S11,COUNTA($H$1:$XFD$1),0)

 

[Asheesh]

Hi pmsrefugee - there is a minor change in the formula...

please use the below one in B1 - VLOOKUP(A1,$H1:$XFD11,COUNTA($H$1:$XFD$1),0)

The difference is highlighted in bold...i.e. table_array arguement of the vlookup function..