Matching Two Conditions and Copying a cell from a Matched condition Formula

**falcons7** · 04-15-2009, 01:03 PM

Hello Everyone, I am trying to update an old list with a current one. What I am trying to do is If a New Field matches the Old Field Copy the field next to the old Field Into a New cell. I have been able to match the two fields, although I cannot seem to figure out how to copy over the field next to the field I am Matching.

Here is the condition I am trying to use.

Please Login or Register  to view this content.

It seems that the part where it says G2 Not correct because when I apply it to all of the colums the G2 Part just goes up by one ex G3, G4 etc instead of copying the field next to the appropriate F field. Please help me

**royUK** · 04-15-2009, 01:07 PM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Functions Forum

**martindwilson** · 04-15-2009, 04:32 PM

try
=IF(ISERROR(MATCH(A2,$F$2:$F$332,0)),"",INDEX(F2:$G$332,MATCH(A2,$F$2:$F$332,0),2))

**falcons7** · 04-15-2009, 06:35 PM

Originally Posted by martindwilson

try
=IF(ISERROR(MATCH(A2,$F$2:$F$332,0)),"",INDEX(F2:$G$332,MATCH(A2,$F$2:$F$332,0),2))

Thanks martindwilson,
Although when i try to apply this to all the cells the INDEX(F2 section goes up by one also. Thus messing up the output, can this be stopped with just the a2 in both spots go up by one?