I need to pull specific data based on multiple criteria

1. I need to pull specific data based on multiple criteria

I have raw data that lists employees for each tender type. I would like to consolidate the information for just some of the tender types, such as cash and service charges, to make a variance tracking sheet. In the attached sample, my data is on the left, in yellow, and where I would like to see it is on the right. I've highlighted in blue the columns that need to pull data from the left. Any help would be greatly appreciated.

2. Re: I need to pull specific data based on multiple criteria

If you have 365 you can use the news functions UNIQUE and XLOOKUP

In K2:
=IFERROR(XLOOKUP(L2,C:C,B:B),"")

In L2:
=UNIQUE(C2:C2000)

3. Re: I need to pull specific data based on multiple criteria

Those columns are not dependant on the data on the left. That list will always remain unchanged. I need to pull cash, fast cash, and service charges based on a match between either columns L and C, or columns K and B

4. Re: I need to pull specific data based on multiple criteria

in which column does this appear:
cash, fast cash, and service charges ?

5. Re: I need to pull specific data based on multiple criteria

you want to sum up all the type of charges per employee?

6. Re: I need to pull specific data based on multiple criteria

I'm trying to pull the data horizontally, so there is only one row for each employee that shows cash, fast cash, and tips. I'll then throw in a formula to tell me how much the employee should have turned in, but I need each item listed separately for reporting purposes. The originating data is all listed in column F

7. Re: I need to pull specific data based on multiple criteria

N2-O36 (assuming the amounts are in G:
=SUMIFS(\$G\$2:\$G\$36,\$B\$2:\$B\$36,\$K2,\$F\$2:\$F\$36,N\$1)

P2 (assuming the service charge amount is in H:
=SUMIFS(\$H\$2:\$H\$36,\$B\$2:\$B\$36,\$K2,\$F\$2:\$F\$36,P\$1)

8. Re: I need to pull specific data based on multiple criteria

I swear, I tried sumifs and couldn't get it to work. I think you just saved my life. Thank you!!!

9. Re: I need to pull specific data based on multiple criteria

I think I know why it didnt work for you - you need to make sure that the titles are exactly the same as the names on your column....otherwise there will no matches found.

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1