# Thread: Vlookup data from a Tables to a single column

1. ## Vlookup data from a Tables to a single column

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

2. 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).

3. 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.

4. tRY:

=IFERROR(INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!\$D\$2:\$K\$2,0)),MATCH(G2,Percentage!A:A,0)),"")

5. Originally Posted by NBVC
tRY:

=IFERROR(INDEX(INDEX(Percentage!D:K,0,MATCH(C2,Percentage!\$D\$2:\$K\$2,0)),MATCH(G2,Percentage!A:A,0)),"")
Thank you! That works! Though it only works on the "Average Feb" table, how would I change it to work on both tables?

7. Are they the only 2 tables?

8. Originally Posted by NBVC
Are they the only 2 tables?
There's a "Average Feb" and an "Average March" for each site

9. 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))),"")

Page 1 of 2 1 2 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•