Updating a cell

[Guest]

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.

 

[Tom Ogilvy]

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.

 

[Guest]

I'm gona give it a try and let you know!

Apprecate the help Tom!

 

[Guest]

Hey Tom gave the formula a try, didn't work.

I'll try to give you a better explaination of what I'm trying to do.

I have two sheets in a workbook.
Sheet 1, Cell A2 is empty and Cell B2 has data.
On sheet 2 Cell A2 and Cell B2 have data.
I want to compare sheet 1 B2 to sheet 2 A2. If I have a match I want sheet 2
B2's data to fill sheet 1 A2.
The catch is I need to look at the entire column of sheet 2 A2 for a match.

The reason for all this is I have a spread sheet filled with data. It was an
export from Access.

Sorry my first explanation was not clear, I posted it with little sleep.

Agian, thanks for any help you can give.

 

[Guest]

Hey Tom I was able to use the Lookup formular to get my results. I never
would have know that if your hadn't replied to my post. I really apprecate
you help man!

Big thanks!