PDA

View Full Version : [SOLVED] Matching cells



austenr
08-24-2005, 06:48 AM
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
08-24-2005, 09:11 AM
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 http://vbaexpress.com/forum/images/smilies/001.gif

In F3:


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

and copy down.