Aladin Akyurek said:Options...
1]
X1:
=MATCH(LValue,1D_LTable,0)
Y1:
=IF(ISNA(X1),"",Y1)
2]
=IF(ISNUMBER(SETV(MATCH(LValue,1D_LTable,0))),"",GETV())
SETV/GETV requires the morefunc add-in.
onlyadrafter said:Hello,
Try this formula, change the cell refs as required.
=IF(ISERROR(MATCH(D11,F12:F15,0)),"",MATCH(D11,F12:F15,0))
Any good?