Comparing VLookup Results vs. Other Values?
Posted by G on September 06, 2000 2:06 PM
I've got a 3500 row spreadsheet (50 columns). Column A lists product id numbers, Column D lists "Instock" status (1 or 0), Column E lists "Discontinued" status (1 or 0).
I'll be receiving an update of this list every week from a vendor....what I want to do is highlight product id's where either the Instock or Discontinued status has changed.
I've tried to create an IF/VLOOKUP statement:
=IF(D2=(VLOOKUP(A2,'[Funworld New.xls]Sheet1'!$A$2:$A$4000,4,FALSE)),0,"Changed") so that I can reference the New sheet vs. the old sheet, but I keep getting #REF! errors.