Vlook Up - two matching row names?

[googledave]

I have been trying to create this for a while now.

The below data would move around on the sheet (row numbers will change).

[TABLE="width: 392"]
<tbody>[TR]
[TD]Source / Medium[/TD]
[TD]Date Range[/TD]
[TD]Visits[/TD]
[/TR]
[TR]
[TD]google / cpc[/TD]
[TD]Oct 1, 2013[/TD]
[TD="align: right"]25,574[/TD]
[/TR]
</tbody>[/TABLE]



I need to pull the visits numbers so i need a vlookup on a hidden sheet that will search for google / cpc and Oct1, 2013 (they will always be next to each other).

I have tried the following to no avail:

=VLOOKUP("google / cpc" + "Oct 1, 2013",'Resourcing Overview Hidden'!A1:Q4999,3,FALSE)

Any help appreciated.

 

[bmacias]

On the hidden sheet add a column on the left hand side of the table and combine the google/cpc column and the Oct 1, 2013 column. (i.e. b2&c2 entered on cell a2)

then you could do the formula your stated earlier but with and "&" instead of a +.

Cheers

 

[bmacias]

And that is the "&" without quotes by the way.