P
Phil T
Can you use VLOOKUP or another function to return a zero
value rather than #N/A if false
value rather than #N/A if false
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi Phil
try
=IF(ISNA(VLOOKUP(.....),0,VLOOKUP(....))
HTH
Frank
try
=IF(ISNA(VLOOKUP(.....),0,VLOOKUP(....))
HTH
Frank
B
Bob Phillips
Hi Phil,
Use
=IF(ISNA(vlookup_formula),0,vlookup_formula)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Use
=IF(ISNA(vlookup_formula),0,vlookup_formula)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
G
Guest
Thanks for prompt answer - can you guide me in!
example: DATA TABLE
A B
1 GOODS VALUE
2 item 1 10
3 item 2 20
4 item 3 30
5
6 item 1 =vlookup(a6,a1:b4,2,false) - gives me 10
7 item 4 =vlookup(a7,a1:b4,2,false) - gives me #N/A
what should the ISNA formula be to get B7 to show zero?
thanks again
example: DATA TABLE
A B
1 GOODS VALUE
2 item 1 10
3 item 2 20
4 item 3 30
5
6 item 1 =vlookup(a6,a1:b4,2,false) - gives me 10
7 item 4 =vlookup(a7,a1:b4,2,false) - gives me #N/A
what should the ISNA formula be to get B7 to show zero?
thanks again
F
Frank Kabel
Hi
try the following
=IF(ISNA(vlookup(a7,a1:b4,2,false)),0,vlookup(a7,a1:b4,2,false))
HTH
Frank
try the following
=IF(ISNA(vlookup(a7,a1:b4,2,false)),0,vlookup(a7,a1:b4,2,false))
HTH
Frank