I was looking to replicate and make it much easier to use the Index and Match function to one UDF
although it works, but it seems to be very slow comparing to the real index and match. also i could not figure out how to handle the error becuase if the value is not found, then it gives "VALUE" error. i was wondering if any of you experts have a better idea to share.
Public Function II_WAY_LOOKUP(Lookup_Value As Variant, Reference_Column As Range, Result_Column As Range)
II_WAY_LOOKUP = WorksheetFunction.Index(Result_Column, WorksheetFunction.Match(Lookup_Value, Reference_Column, 0), 1)