thefunstarts
New Member
- Joined
- Apr 19, 2015
- Messages
- 47
I'm having an issue with a piece of VBA used to insert an Index Match formula. Below is the code I'm using but it's returning an error - I can't figure out why! Can anyone help?!
Code:
Range("E8").Formula = "=IFERROR(INDEX('Data'!$C$2:$XFD$10000, MATCH(1,('Data'!$C$2:$C$10000=Dashboard!$B8)*('Data'!$I$2:$I$10000=Dashboard!$E$6),0),12),"")"