I would like a cell to display whichever value in a row is the furthest to the right (or the most recent, in this case). The excel spreadsheet will have additional columns added to it over time.

Specifically: in row 42, data will be recorded intermittently. The data entries in row 42 start in column B. Cell F3 should display whichever is the most current value in row 42.

I have tried to use the offset function with a built in count function from doing some research online but I can't seem to have it worked out so the correct value displays. Not sure what I am doing wrong!