=IFERROR.....didn't work.
I tried the Index/Match combination
=INDEX(Sheet2!B15:B37(MATCH(A1,Sheet2!A15:A37,0))
it may work...but I am getting an
error message saying "Your formula is missing a parenthesis--) or (.
Quote:
Originally Posted by Pecoflyer
Try =IFERROR(VLOOKUP(A1,Sheet2!A15:B37,2),"")
Be aware that INDEX/MATCH combination is much more flexible ( and faster on large ranges) than VLOOKUP
|