Hi
I have it out Vba using dynamic named range and index n match formula to look up array and get out put

I want to do it using VBA....set up range and lookup and get values using index and match functions