=IFERROR(VLOOKUP(($I$3,$J$2,$D$13),INDIRECT("'[CRE Database.xlsm]"&$C$3&"'!$W$3:$AC$20"),3,FALSE),"$0")
Is there a different way that I could be going about this? Not only will excel not let me enter this as an array because a couple of the cells happen to be merged, but even if it did allow me to enter it as an array, would it even work? I've never tried to use a vlookup with 3 search criteria before.
Any help I can get is greatly appreciated!
Edit Post: I updated this post to highlight in red where I know I'm having my issue.
Bookmarks