# Need help with XLookup formula searching across three values

#### Florida1510

##### New Member
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
246.6 KB · Views: 11

### 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
What should the end result look like?

#### Florida1510

##### New Member
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
251.1 KB · Views: 6

Replies
7
Views
104
Replies
2
Views
163
Replies
17
Views
272
Replies
0
Views
41
Replies
3
Views
75

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.

### Which adblocker are you using?

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

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