I'd like to apologize in advance if this is in the wrong area of the forums.
I was trying to run a vlookup on multiple worksheets and came across this formula while searching the net:
=VLOOKUP(B2,INDIRECT("'"&INDEX(D2:D8,MATCH(TRUE,COUNTIF(INDIRECT("'"&D2:D8&"'!C1:C25"),B2)>0,0))&"'!C1:P25"),2,0)
Now I managed to get it to work with what I was doing. My problem is, I have on idea how this formula works. Like the Indirect function? And what is the purpose of the "'" and &? Or the >0?
I can look at a simple vlookup formula and break down what each part is doing. But I have no idea where to start with this.
I realize this is probably a lot to ask. Hopefully someone will have enough free time and knowledge to help me with this.
Bookmarks