Hi all,
I found a solution to my 1st problem via this old threadhttps://www.mrexcel.com/forum/excel-questions/775611-if-vlookup-blank-one-column-then-vlookup-another-column.html
My resultant formula that works is "=IFNA(IF(A11="","",LOOKUP(99^99,VLOOKUP(A11,'DDL SW'!G:AQ,{21,23,29,32,37},FALSE))),"")"
My next problem is that I want the formula to look through the columns 37,32,29,23,21 and when it finds an entry (a date in my case) to return the value of the next column. I.e. if 37 is blank, check 32, if 32 is blank, check 29, if there is an entry in 29 then return the value of 23.
I doubt there is a way of doing this without seriously changing up the formula but I thought i'd ask.
Thanks,
David
<strike></strike>
I found a solution to my 1st problem via this old threadhttps://www.mrexcel.com/forum/excel-questions/775611-if-vlookup-blank-one-column-then-vlookup-another-column.html
My resultant formula that works is "=IFNA(IF(A11="","",LOOKUP(99^99,VLOOKUP(A11,'DDL SW'!G:AQ,{21,23,29,32,37},FALSE))),"")"
My next problem is that I want the formula to look through the columns 37,32,29,23,21 and when it finds an entry (a date in my case) to return the value of the next column. I.e. if 37 is blank, check 32, if 32 is blank, check 29, if there is an entry in 29 then return the value of 23.
I doubt there is a way of doing this without seriously changing up the formula but I thought i'd ask.
Thanks,
David
<strike></strike>