n/a in vlookup/index/match formula

Hi,

I have a formula which works except that if a cell(a53) is blank I get a n/a value. How can I make the value be blank when the value in a53 is blank as well.

the formula is -

=vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)

if a53 is blank the cell result is n/a

thanks

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi Mangesh

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52 :i61,2,false)
)

this works, however

a53 is a date

when I put in the next cell (a53+1) as the next day it doesn't work

ie.
=if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
h52:i61,2,false)
)

any ideas.

andrewm

sorry mangesh,

the formula i used

=if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
h52 :i61,2,false)
)

thanks

andrewm

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

=if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" <andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com> wrote in
message news:andrewm.1rsi7l_1120723570.4045@excelforum-nospam.com...
>
> Hi,
>
> I have a formula which works except that if a cell(a53) is blank I get
> a n/a value. How can I make the value be blank when the value in a53 is
> blank as well.
>
> the formula is -
>
> =vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52:i61,2,false)
>
> if a53 is blank the cell result is n/a
>
> thanks
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Hi,

I did not get you. You need to check A54, or what is it. What does A53+1
mean. In that case it is no longer blank.

If A54 is what you want to check, then
=if((A54)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),h52
:i61,2,false))


Mangesh




"andrewm" <andrewm.1rsqii_1120734388.818@excelforum-nospam.com> wrote in
message news:andrewm.1rsqii_1120734388.818@excelforum-nospam.com...
>
> sorry mangesh,
>
> the formula i used
>
> =if((A53+1)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52 :i61,2,false)
> )
>
> thanks
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>

Maybe, in the next cell you should put
=IF(A53="","",A53+1)

And then follow it up with your VLOOKUP

Mangesh


"andrewm" <andrewm.1rsqih_1120734388.0641@excelforum-nospam.com> wrote in
message news:andrewm.1rsqih_1120734388.0641@excelforum-nospam.com...
>
> Hi Mangesh
>
> =if(A53="","",vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52
> :i61,2,false)
> )
>
> this works, however
>
> a53 is a date
>
> when I put in the next cell (a53+1) as the next day it doesn't work
>
> ie.
> =if((A53+)="","",vlookup(index(f52:f61,(match((a53+1),e52:e61,0))),
> h52:i61,2,false)
> )
>
> any ideas.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=385168
>