Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |