This is displaying the formula instead of the result of the formula

[pfulghum]

=IF(ISNA(VLOOKUP(TRIM(A3),'Vendor Leadtime'!J:N,5,FALSE)),"VLOOKUP(D3,'Vendor Leadtime'!A:C,3,FALSE))",VLOOKUP(D3,'Vendor Leadtime'!A:C,3,FALSE))


VLOOKUP(D3,'Vendor Leadtime'!A:C,3,FALSE))" is what is being displayed instead of the result of it. What am I missing?

[RHCPgergo]

You put the formula between "" signs, so it is recognized as text.

[TheNewUnion]

Haing this ,"VLOOKUP(D3,'Vendor Leadtime'!A:C,3,FALSE))" in quotes means that it will put the text in rather than run the formula, maybe?

(beaten to it by poster above)

[RHCPgergo]

Take that TheNewUnion! :P
I've been beaten so many times, but now I finally took revenge. Sweet, sweet victory...

[pfulghum]

IT errors out when i remove the quotes?

[Ace_XL]

Maybe you want..

Please Login or Register  to view this content.

[pfulghum]

I will try that in the morning thank you.