Cheers for that, it kinda works, but i need the A2 part of the formula to
move down with initial part of the formula eg. f2 and a2, f44 and a44 and so
forth.

"Leo Heuser" wrote:

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