Hi all,
It is my first time trying to create a user defined function from scratch (previously just copied from internet when needed) but haven't been able to crack this.
The idea is to have a user defined function for each match lookup rather than having the entire formula each time which can get messy if multiple arguments are going to be used.
So for the below formula, the user defined INDEX-MATCH function would be named after the MATCH field e.g. CodeType
=IF($B2=C$1,INDEX(Raw!$B:$U,ROW(),MATCH("CodeType",Raw!$B$1:$U$1,0)),"")
becomes
=IF($B2=C$1,CodeType(),"")
Likewise, for:
=IF($B2=I$1,INDEX(Raw!$B:$U,ROW(),MATCH("Description",Raw!$B$1:$U$1,0)),"")
becomes
=IF($B2=C$1,Description(),"")
So INDEX(Raw!$B:$U,ROW(),MATCH("XYZ",Raw!$B$1:$U$1,0)) would be XYZ()
I appreciate any and all help, and let me know if you need further clarification.
Thanks
Bookmarks