Vlookup to Equal Zero?
Worked perfect, thank you!
"Jim Thomlinson" wrote:
Something like this should do
=if(countif('9-7Turnover'!$A$1:$A$32, A2) = 0, 0, VLOOKUP(A2,
'9-7Turnover'!$A$1:$F$32, 6, FALSE))
--
HTH...
Jim Thomlinson
"57Caddy" wrote:
Hello,
I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't find
the item looked up?
=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)
Thank you
|