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.
|