=IF(VLOOKUP(B12,$R$12:$W$2500,3,FALSE)=C12,"Good", (VLOOKUP(B12,$R$12:$W$2500,3,FALSE)-C12))

How about this one.. basically of the vlookup = C12.. then I want it to
tell me its Good.. otherwise if the quanitites do not match.. i want the
vlookup in one column to subtract from a corresponding cell.. and I want
the ISNA in there in case the cell doesn't exist in other set of data.
Thanks

- Amar


--
amario
------------------------------------------------------------------------
amario's Profile: http://www.excelforum.com/member.php...o&userid=26858
View this thread: http://www.excelforum.com/showthread...hreadid=401211