#N/B errro with vertical lookup

  • Thread starter Jean-Paul De Winter
  • Start date
J

Jean-Paul De Winter

Hi,
I have this formula:
=VERT.LOOKUP(B2;$J$2:$K$8;2)
J2 through K8 is:

2 maandag
3 dinsdag
4 woensdag
5 donderdag
6 vrijdag
7 zaterdag
1 zondag

Everything works just fine except when the value of B is 1, then I get
#N/B in the corresponding cell

Waht to do?
Thanks
 
T

T. Valko

Try this:

=VERT.LOOKUP(B2;$J$2:$K$8;2;0)

I'm "guessing" that VERT.LOOKUP is the equivalent of VLOOKUP in ENGLISH. If
so, then the arguments should be the same.

Biff
 
N

Niek Otten

With the 4th argument omitted, the list should be sorted.

Use

=VERT.LOOKUP(B2;$J$2:$K$8;2;ONWAAR)

instead.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi,
| I have this formula:
| =VERT.LOOKUP(B2;$J$2:$K$8;2)
| J2 through K8 is:
|
| 2 maandag
| 3 dinsdag
| 4 woensdag
| 5 donderdag
| 6 vrijdag
| 7 zaterdag
| 1 zondag
|
| Everything works just fine except when the value of B is 1, then I get
| #N/B in the corresponding cell
|
| Waht to do?
| Thanks
 
N

Niek Otten

Yes. Dutch.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| >ONWAAR
|
| Does that mean FALSE?
|
| Biff
|
| | > With the 4th argument omitted, the list should be sorted.
| >
| > Use
| >
| > =VERT.LOOKUP(B2;$J$2:$K$8;2;ONWAAR)
| >
| > instead.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | > | Hi,
| > | I have this formula:
| > | =VERT.LOOKUP(B2;$J$2:$K$8;2)
| > | J2 through K8 is:
| > |
| > | 2 maandag
| > | 3 dinsdag
| > | 4 woensdag
| > | 5 donderdag
| > | 6 vrijdag
| > | 7 zaterdag
| > | 1 zondag
| > |
| > | Everything works just fine except when the value of B is 1, then I get
| > | #N/B in the corresponding cell
| > |
| > | Waht to do?
| > | Thanks
| >
| >
|
|
 
Top