return text when values don't match

[JakeMann]

Hi All,

Need some help-

On the attached spread sheet I need a formula in 'AUTHORISED FOR DESTRUCTION' N2 that looks at C2 in 'hb 30092013'

If the value in C2 doesn't appear in 'AUTHORISED FOR DESTRUCTION' then I want to return the word 'DESTROYED'.

Any ideas?

[anghicole]

Where exactly in the 'AUTHORISED FOR DESTRUCTION' should you find the C2 value from 'hb 30092013' to be displayed, anywhere in the sheet?

[ARGK]

Hi Jake
Use this formula:
=IF(ISERROR(VLOOKUP('hb 30092013'!C2,'AUTHORISED FOR DESTRUCTION'!C:C,1,FALSE)),"DESTROYED","")
Good luck.
Tony

[MarvinP]

Hi Jake,

Try this in N2 and copy it down..

=IFERROR(VLOOKUP(C2,'hb 30092013'!C1:C1193,1,FALSE),"DESTROYED")