Is this possible to do?

markdoc5

New Member
Joined
Jan 27, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hi Folks!

Not sure if this is even possible to do (I'm a rookie) - please ignore the #Name i know the formula as is works its just because i have saved it on another PC on a old version of excel to send this and i had to change the names for privacy reasons.

so basically i have 2 tables the "call data" and the table2 - i do have a pivot for table 2 and this is where im running into bother, basically the formula im using pulls the the data on table 2 from call data however both have 2 sets of dates because they are different data sets and i cant merge them, is it possible to also match the date from table 2 to call data date then the forumla to pull what i need? if that makes any sense ! tried a few things but cant seem to get it working - i have uploaded some screenshots with the formula in place - ill owe someone a very large Whisky if they can solve :D
 

Attachments

  • excelhelp1.png
    excelhelp1.png
    204.3 KB · Views: 17
  • excelhelp2.png
    excelhelp2.png
    162 KB · Views: 17

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

markdoc5

New Member
Joined
Jan 27, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
anyone, or is it a case of it cant be done?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,180
Messages
5,623,216
Members
415,957
Latest member
Newguy1924

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
Top