text substitution

[Mark]

I have a spread sheet that tracks equipment for our company. I split the
screen because I record fuel usage and meter readings on a number of pieces
of equipment. Part of the record indicates which of our project sites the
equipment is located at. At the beginning of the month, I type the site
location in a cell and as the month progress, I type the name of the new site
if the equipment moves in a cell on that same line. What I would like to do
is have the original cell be updated any time I type a new location in that
line. Any help would be appreciated.

 

[Gary''s Student]

Let's say you want cell A1 to contain the most recent value in the first row.
So if we start with a value in B1, then we see that value in A1. If we
later enter a value in C1, then A1 changes to this value.

The desire is that A1 reflect he last (right-most) value in the row. In A1
enter:

=LOOKUP(2,1/($B$1:$IV$1>0),$B$1:$IV$1)

this should do the trick.

 

[Mark]

I tried your solution, but I get an error #VALUE!. I think this is because I
am looking to replace text and not a number. If you think I'm donig
something wrong in my formula, please let me know. thanks.

Also, do I need to be using "hlookup" since I'm using a row?