Matching cells

[austenr]

Hi everyone,

I have a file that I need to compare. I need to compare columns B and G. The number in column G can occure anywhere in the column. If a match is found I need the value in cell A moved to the matched number in column F. I have attached a spreadsheet with an example. Thanks for your help.

[Bob Phillips]

Hi everyone,

I have a file that I need to compare. I need to compare columns B and G. The number in column G can occure anywhere in the column. If a match is found I need the value in cell A moved to the matched number in column F. I have attached a spreadsheet with an example. Thanks for your help.

More worksheet functions

In F3:

=IF(ISNA(MATCH(G3,B:B,0)),"",INDEX(A:A,MATCH(G3,B:B,0)))

and copy down.