n/a in vlookup/index/match formula

[andrewm]

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

 

[Mangesh Yadav]

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

Mangesh

 

[andrewm]

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]

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

 

[Mangesh Yadav]

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

 

[Mangesh Yadav]

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

And then follow it up with your VLOOKUP

Mangesh