=IF(ISNA(VLOOKUP($D19,'[Fee
File.xls]Fees'!$C$13:$H$20108,1,0)),"COR",VLOOKUP($D19,'[Fee
File.xls]Fees'!$C$13:$H$20108,1,0))
"Susana C via OfficeKB.com" wrote:
I searched a the "Correct #N/A Error" threads and found some info on isna and
iserror, but I must be doing something wrong. For any item that is not found
in the following lookup, I would like the "COR" to be returned. How do I do
this? I am using the ,0 at the end in liu of "false" because "false" does
not work when you have multiple active filters working.
=VLOOKUP($D19,'[Fee File.xls]Fees'!$C$13:$H$20108,1,0)
Thank you!
--
Message posted via http://www.officekb.com