Hello,

I am trying to get a macro that uses the IndexMatch Formula but has pop up windows for the person running the macro to select the range and the data to look up. I
have tried a lot but I am not very good at VBA but still trying. The formula I am using is

{=INDEX("User selects range",MATCH("user selects"&"user selects","user selects first column"&"User selects 2nd column",0),"user selects column number to return answer")}



=INDEX(L2:U10,MATCH(C13&D13,B5:C20&C5:C24,0),3)

I have attached the example worksheet with the formula working where I need it, I just need a macro to do the same thing with a user being able to select all the variables.example.xlsx