Vlookup

G

glen.e.mettler

I have a field in sheet "NewData" with this formula:
=IF(VLOOKUP(A1,Analysis!$A$3:$A$310,1,0)>0,"","NEW")

Problem:
When I add rows to sheet "Analysis", it adds numbers to $A$3 - ie if I
add 10 rows to "Analysis", the formula becomes ...$A$13...
Thus the first rows of any new data don't get interogated since the
lookup starts at row 13 instead of 3

I need the lookup always to start at $A$3

How can I keep it from incrementing?

Glen
 
R

Roger Govier

Hi Glen

It sounds as though the following might work
=IF(MATCH(A1,Analysis$A:$A)>0,"","NEW")
dependent upon what might be in cells Analysis!$A1:$A2
If they contained the same value as Newdata!A1, then set the >0 to >1.

Regards

Roger Govier
 
Top