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


--
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" wrote in
message ...

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


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=385168

sorry mangesh,

the formula i used

=if((A53+1)="","",vlookup(index(f52:f61,(match((a5 3+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

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" wrote in
message ...

sorry mangesh,

the formula i used

=if((A53+1)="","",vlookup(index(f52:f61,(match((a5 3+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" wrote in
message ...

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