Hi Rikki

How about:

=IF(F2="new",vlookup(A2,p,2,0),0)


--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Chiccada" skrev i en meddelelse
...
Hi all,

Got a quick question for ya's.

I am currently trying to hash out a formula along these lines:
=IF(F2="new","=vlookup(A2,p,2,0)",0)

I have tried adding the 'indirect' function but it still brings me no joy.

Any help would be greatly appreciated.

Regards,

Rikki