Thread: Updating a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Updating a cell

In the empty cell - for example purposes, assume it is F2 and the cell with
a value is G2. We are looking in Sheet2 in columns B:C

=Vlookup(G2,Sheet2!B:C,2,False)

Then if there are more values in column G, drag fill the formula down column
F.

--
Regards,
Tom Ogilvy

"Brian3D" wrote in message
...
I need to know how to do the following.

I have an empty cell next to a cell with a value.
I want to take that cell with a value and compare it to the values found
in
a column contained in another worksheet. That column would have a
companion
cell that contains a value.
When a match is found I want the original empty cell to contain the value
of
the companion cell next to the column were the matching value was found.

So if my original value was 8, I find 8 in a cell in the column, the
companion cell value was 88, then my original empty cell would get a value
of
88.

I hope I explained that clearly enough.