vlookup avoiding #N/A

**Lillian Eik** · 07-05-2005, 12:06 PM

Hi!

If anybody know a way around this I'll be forever thankfull.

I have a standard list which uses vlookup to another list which varies. If there is not a match I get #N/A and that messes up my subtotals in the first list. I have tried variations with if, match and find but I can not make it work.

How can I get Excel to reply "" or 0 instead of #N/A?

N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
N2=FD312 Insurance

Thanks in advance

**swatsp0p** · 07-05-2005, 12:41 PM

If we use ISERROR to trap error messages, we can prevent them from showing up, as such:

=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

The first part of the formula looks to see if the result is an error and if so, returns the empy string "". If no error is found, the result of the formula is returned.

HTH

Bruce

N Harkawat · 07-05-2005, 01:05 PM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 07-05-2005, 01:05 PM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Peo Sjoblom · 07-05-2005, 01:05 PM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 07-05-2005, 04:05 PM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

**swatsp0p** · 07-06-2005, 10:03 AM

Thanks for the tip, Gord. I'll keep that in mind as I evaluate the need for error trapping methods.

Cheers!

Bruce

N Harkawat · 09-05-2005, 10:05 PM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-05-2005, 10:05 PM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Peo Sjoblom · 09-05-2005, 10:05 PM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-05-2005, 10:05 PM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Gord Dibben · 09-05-2005, 11:05 PM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Peo Sjoblom · 09-05-2005, 11:05 PM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-05-2005, 11:05 PM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

N Harkawat · 09-05-2005, 11:05 PM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

N Harkawat · 09-06-2005, 12:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-06-2005, 12:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Gord Dibben · 09-06-2005, 12:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Peo Sjoblom · 09-06-2005, 12:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Peo Sjoblom · 09-06-2005, 01:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 01:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Odie · 09-06-2005, 01:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

N Harkawat · 09-06-2005, 01:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

N Harkawat · 09-06-2005, 02:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 02:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Peo Sjoblom · 09-06-2005, 02:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-06-2005, 02:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Odie · 09-06-2005, 03:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Peo Sjoblom · 09-06-2005, 03:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

N Harkawat · 09-06-2005, 03:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 03:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

N Harkawat · 09-06-2005, 04:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 04:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Odie · 09-06-2005, 04:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Peo Sjoblom · 09-06-2005, 04:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 06:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Peo Sjoblom · 09-06-2005, 06:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-06-2005, 06:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

N Harkawat · 09-06-2005, 06:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 07:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

Peo Sjoblom · 09-06-2005, 07:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-06-2005, 07:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

N Harkawat · 09-06-2005, 07:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

N Harkawat · 09-06-2005, 10:05 AM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-06-2005, 10:05 AM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Peo Sjoblom · 09-06-2005, 10:05 AM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 10:05 AM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

N Harkawat · 09-06-2005, 12:05 PM

=if(iserror(match(b2;c:c;0)),"",VLOOKUP(B2;Internal!B:C;2;FALSE))

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Odie · 09-06-2005, 12:05 PM

try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile: http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>
>

Peo Sjoblom · 09-06-2005, 12:05 PM

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2;Internal!B:C;2;FALSE);"")

--
Regards,

Peo Sjoblom

(No private emails please)

"Lillian Eik" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
>
> If anybody know a way around this I'll be forever thankfull.
>
> I have a standard list which uses vlookup to another list which varies.
> If there is not a match I get #N/A and that messes up my subtotals in
> the first list. I have tried variations with if, match and find but I
> can not make it work.
>
> N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
> N2=FD312 Insurance
>
> Thanks in advance
>
>
> --
> Lillian Eik
> ------------------------------------------------------------------------
> Lillian Eik's Profile:
> http://www.excelforum.com/member.php...o&userid=24919
> View this thread: http://www.excelforum.com/showthread...hreadid=384575
>

Gord Dibben · 09-06-2005, 12:05 PM

Just a head's up on ISERROR

It will mask all errors, not just the #N/A and may hide something you don't
want hidden.

Preferable to use the ISNA function.

=IF(ISNA(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)

Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:41:21 -0500, swatsp0p
<[email protected]> wrote:

>
>If we use ISERROR to trap error messages, we can prevent them from
>showing up, as such:
>
>=IF(ISERROR(VLOOKUP(B2;Internal!B:C;2;FALSE)),"",VLOOKUP(B2;Internal!B:C;2;FALSE)
>
>The first part of the formula looks to see if the result is an error
>and if so, returns the empy string "". If no error is found, the
>result of the formula is returned.
>
>HTH
>
>Bruce

vlookup avoiding #N/A

LinkBack

Thread Tools

Rate This Thread

Display

vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

RE: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Re: vlookup avoiding #N/A

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions