Construction of embedded If function

[markDuffy]

Hi Guys

I am trying to construct a function using and if and a vlookup.

The result of this code

Please Login or Register  to view this content.

is Yes. In this case I would like to enter the value in T2. if true then "-".
This is what I have but it does not work:

Please Login or Register  to view this content.

Please can someone tell me where I am wrong.

Thanks

Mark

[etaf]

the vlookup will be returning a value if found or an N/A if not found - so you need to turn that into a true or false
=IF( ISERROR( VLOOKUP(P2,CatToVatType,4,FALSE)) , " -", T2)

[markDuffy]

Fantastic. I really have so much to learn.Thanks ever so much I had tried all sorts of variations.