Are we going to look only at the left tables in Percentage tab? I don't see anything in the vlookup tab to match day (number).
Hi Guys,
I'm trying to take the data from the "percentage" tab to the "vlookup" tab into one single column. (Ive already started as an example)
I could just drag it down, but it would take way too long due to the column change.
Is there a easier method than this? This is only an example data my original has more than 50 sites and more dates.
iDummy
Are we going to look only at the left tables in Percentage tab? I don't see anything in the vlookup tab to match day (number).
We would look at all of "Victory"'s data first before moving to the next site.
I set up the vlookup tab exactly how its meant to look like, though I cant figure a way to extract the data without spend hours and hours of time.
tRY:
=IFERROR(INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!$D$2:$K$2,0)),MATCH(G2,Percentage!A:A,0)),"")
Cross post http://www.excelforum.com/excel-form...le-column.html
Please read http://www.excelguru.ca/content.php?184 about cross posting - Thx
Linked Thank you!
Are they the only 2 tables?
Try:
=IFERROR(IF(B2="Average Feb",INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!$D$2:$K$2,0)),MATCH(G2,Percentage!A:A,0)),INDEX(INDEX(Percentage!O:V,0,MATCH(C2,Percentage!$O$2:$V$2,0)),MATCH(G2,Percentage!A:A,0))),"")
Bookmarks