Vlookup Question (Please help)

B

barham

New Member
Joined
Jan 13, 2015
Messages
26
I have two tables pictured below:

Table 1[TABLE="width: 1378"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Columns[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rows[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Day of month[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Date[/TD]
[TD]2/18/2015[/TD]
[TD]2/19/2015[/TD]
[TD]2/20/2015[/TD]
[TD]2/21/2015[/TD]
[TD]2/22/2015[/TD]
[TD]2/23/2015[/TD]
[TD]2/24/2015[/TD]
[TD]2/25/2015[/TD]
[TD]2/26/2015[/TD]
[TD]2/27/2015[/TD]
[TD]2/28/2015[/TD]
[TD]3/1/2015[/TD]
[TD]3/2/2015[/TD]
[TD]3/3/2015[/TD]
[TD]3/4/2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Month[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]March[/TD]
[TD]March[/TD]
[TD]March[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]Service[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sales[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD]Reserve[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD] Table 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD]Day of month[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD]Service[/TD]
[TD]Month[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD]January[/TD]
[TD]25[/TD]
[TD]14[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD]11[/TD]
[TD]19[/TD]
[TD]19[/TD]
[TD]28[/TD]
[TD]22[/TD]
[TD]14[/TD]
[TD]23[/TD]
[TD]22[/TD]
[TD]9[/TD]
[TD]13[/TD]
[TD]23[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD]February[/TD]
[TD]32[/TD]
[TD]18[/TD]
[TD]17[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]21[/TD]
[TD]15[/TD]
[TD]32[/TD]
[TD]25[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]23[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]29[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[TD]March[/TD]
[TD]25[/TD]
[TD]17[/TD]
[TD]29[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]30[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]23[/TD]
[TD]23[/TD]
[TD]21[/TD]
[TD]18[/TD]
[TD]14[/TD]
[TD]17[/TD]
[TD]23[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD]Sales[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD]January[/TD]
[TD]28[/TD]
[TD]15[/TD]
[TD]26[/TD]
[TD]14[/TD]
[TD]11[/TD]
[TD]25[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]20[/TD]
[TD]29[/TD]
[TD]27[/TD]
[TD]23[/TD]
[TD]12[/TD]
[TD]17[/TD]
[TD]26[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD]February[/TD]
[TD]35[/TD]
[TD]18[/TD]
[TD]21[/TD]
[TD]14[/TD]
[TD]12[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]42[/TD]
[TD]26[/TD]
[TD]24[/TD]
[TD]26[/TD]
[TD]25[/TD]
[TD]10[/TD]
[TD]22[/TD]
[TD]32[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD]March[/TD]
[TD]33[/TD]
[TD]22[/TD]
[TD]22[/TD]
[TD]11[/TD]
[TD]17[/TD]
[TD]33[/TD]
[TD]24[/TD]
[TD]32[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]21[/TD]
[TD]35[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
On cell C5 I want a vlookup function that will look at both table 1 and table 2 to get me the corresponding data. If the day of the month ranging from 18 - 4 are the same, the dept are the same (Service,sales, etc) and the Month from Table 1 is the same, get me the data within the range of C15:Q21.

I will be very thankful if someone can assist.

Thank you
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Hi

Try this formula in cell C5 :-

SUMPRODUCT(($A$15:$A$21=$B5)*($B$15:$B$21=C$4)*($C$13:$Q$13=C$2)*$C$15:$Q$21)

Cheers
Chris
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Age Group Ranging by gender
Replies
2
Views
231
Raj1979
R
SRMPURCHASE
  • Question Question
#NUM! ERROR
Replies
2
Views
226
SRMPURCHASE
SRMPURCHASE
F
  • Question Question
Changing date format based on fiscal years versus calendar years
Replies
2
Views
164
Peter_SSs
Peter_SSs
A
  • Solved
Count entry by time
Replies
3
Views
164
admvlad
A
S
  • Solved
Individual Ranking
2
Replies
11
Views
433
sksanjeev786
S

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top