F
Finny388
I have a formula in B:B that looks like this
=IF(ISERROR(MATCH(VLOOKUP(A1,I:J,2,FALSE),'$M:$M,0)),"Not Found","")
but
the VLOOKUP is standard. it always looks up adjacent cell in I and
returns J
VLOOKUP option always FALSE
MATCH option always 0
I think a VBA function could reduce it to this
=MYFIND(A1,$M:$M)
I know to store a function in a module in personal.xls but and I don't
know how to mimick these 3 formulas.
Any help appreciated.
thanks
=IF(ISERROR(MATCH(VLOOKUP(A1,I:J,2,FALSE),'$M:$M,0)),"Not Found","")
but
the VLOOKUP is standard. it always looks up adjacent cell in I and
returns J
VLOOKUP option always FALSE
MATCH option always 0
I think a VBA function could reduce it to this
=MYFIND(A1,$M:$M)
I know to store a function in a module in personal.xls but and I don't
know how to mimick these 3 formulas.
Any help appreciated.
thanks