Need help with XLookup formula searching across three values

Florida1510

New Member
Joined
Mar 13, 2020
Messages
14
Office Version
  1. 2010
Platform
  1. Windows
Folks,

Good afternoon, I hate to ask but after two hours I’m here to ask for some assistance. I need to be able to pull in my device count and revenue onto my monthly spreadsheet. I had written a Vlookup formula that worked problem is I didn’t take into consideration if I put that formula in my next month I would get the same results if I didn’t tell it to also search by month. My two common identifiers are ACCTID and Billing Cycle. I can figure out how to look at it for a single search but I can’t seem to figure out how to make it also search by month. I have attached a screenshot of what my data looks like.

Any help would be greatly appreciated. Thanks in advance.

Owen
 

Attachments

  • BEB4FA0F-E404-4685-8D57-8370E14F1A5C.png
    BEB4FA0F-E404-4685-8D57-8370E14F1A5C.png
    246.6 KB · Views: 11

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

xlyfe

Board Regular
Joined
Aug 28, 2020
Messages
53
Office Version
  1. 365
Platform
  1. Windows
What should the end result look like?
 

Florida1510

New Member
Joined
Mar 13, 2020
Messages
14
Office Version
  1. 2010
Platform
  1. Windows
Xlyfe, hello I’m looking for it to return the number found in the Terminals field in the Devices field. So the formula will need to look at the ACCTID and the month header to pull back that data. Right now I have a straight Vlookup the problem is if I put that formula in the next month device field it will pull back the same data I. The previous month field because the formula is not also looking at the month. I have updated the screenshot. Thanks for all your assistance.

Owen
 

Attachments

  • 849D0C2C-F5A2-427E-9CB8-F50FD8C739FA.png
    849D0C2C-F5A2-427E-9CB8-F50FD8C739FA.png
    251.1 KB · Views: 6

Watch MrExcel Video

Forum statistics

Threads
1,127,742
Messages
5,626,618
Members
416,195
Latest member
tonmcg

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