Need help with a formula maybe "Match"

J

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,032
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have this table of information, I need a formula in cell E3 in the bottom table that would look at the top table and return the pay time for that employee number and that date. I would need a formula for F - I row 3 also but if you could suggest one for E3 I think I could figure the rest out.
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>I</b></td><td align="center" bgcolor="#C0C0C0"><b>J</b></td><td align="center" bgcolor="#C0C0C0"><b>K</b></td><td align="center" bgcolor="#C0C0C0"><b>L</b></td><td align="center" bgcolor="#C0C0C0"><b>M</b></td><td align="center" bgcolor="#C0C0C0"><b>N</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Emp# </td><td rowspan="1" colspan="1" width="165" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Employee Name </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Date </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Time On </td><td rowspan="1" colspan="1" width="114" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Time Off </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Pay Time </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8001 </td><td rowspan="1" colspan="1" width="165" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Employee A </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">4/26 </td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13:57 </td><td rowspan="1" colspan="1" width="114" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">22:39 </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">8:12 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>4</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8013 </td><td rowspan="1" colspan="1" width="165" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Employee B </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">4/25 </td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6:00 </td><td rowspan="1" colspan="1" width="114" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">14:42 </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">8:12 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>5</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8014 </td><td rowspan="1" colspan="1" width="165" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Employee c </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">4/25 </td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6:00 </td><td rowspan="1" colspan="1" width="114" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">15:42 </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">8:12 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>6</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8015 </td><td rowspan="1" colspan="1" width="165" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Employee d </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">4/25 </td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6:00 </td><td rowspan="1" colspan="1" width="114" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">14:00 </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">8:12 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>7</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8016 </td><td rowspan="1" colspan="1" width="165" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Employee e </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">4/25 </td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6:00 </td><td rowspan="1" colspan="1" width="114" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF">14:42 </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">8:12 </td></tr>
</table>
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>B</b></td><td align="center" bgcolor="#C0C0C0"><b>C</b></td><td align="center" bgcolor="#C0C0C0"><b>D</b></td><td align="center" bgcolor="#C0C0C0"><b>E</b></td><td align="center" bgcolor="#C0C0C0"><b>F</b></td><td align="center" bgcolor="#C0C0C0"><b>G</b></td><td align="center" bgcolor="#C0C0C0"><b>H</b></td><td align="center" bgcolor="#C0C0C0"><b>I</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Emp# </td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF">Shift </td><td rowspan="1" colspan="1" width="249" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Employee Name </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">25-Apr </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">26-Apr </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">27-Apr </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">28-Apr </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">29-Apr </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">8004 </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="249" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Employee A </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF"> </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF"> </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF"> </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF"> </td><td rowspan="1" colspan="1" width="96" height="30" align = "center" valign = "bottom" bgcolor ="#FFFFFF"> </td></tr>
</table>
 
Sort by date Sort by votes

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E
E
  • Solved
If Formula
Replies
1
Views
98
DanteAmor
DanteAmor
F
  • Question Question
VBA Macro Issue: Replacing Simple Formula with Complex Formula Causes Error
Replies
2
Views
105
flashgordie
F
D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Forum statistics

Threads
1,224,586
Messages
6,179,719
Members
452,939
Latest member
WCrawford

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