Hi

This is exactly what we both did say. You can have in column SS2!B:B either
VLOOKUP formula, or previous value. But not both!

Maybe 3rd column will do for you - where the value from sheet SS1 is
displayed, when such is present, or the value from column B is displayed,
when no matching entry exists in SS1!A:A. Like
C2=IF(ISERROR(VLOOKUP(A2,SS1!$A$2:$B$100,2,0)),B2, VLOOKUP(A2,SS1!$A$2:$B$100
,2,0))
NB! You can't have this formula in column B !!!


Arvi Laanemets


"Jay" wrote in message
oups.com...
Ok. Maybe I should clarify.

My requirement is -
I have two spreadsheets (SS1 & SS2) with, say, two columns (A & B)
each.

My source list is SS1-Columns A&B.
My target list is SS2-Columns A&B.

I'd like to lookup items in target SS2-Col A in source SS1-Col A and if
there is a match
- REPLACE target SS2-Col B with source SS1- Col B.
If there is NO match
- Leave target SS2-Col B alone without replacing it with blank, 0 or
#NA.

I was typing the IF<ISNA<VLOOKUP formula (in previous email) in the
target SS2-Col B cell and expecting it to either REPLACE or retain the
previous value it had before the formula was typed - bummer.

Well, if I can't use this formula to do that, How could I do this?
- Thanks