Forum Discussion
Skpenu505
Nov 13, 2019Copper Contributor
EXCEL URGENT HELP!
Hi, I recently joined the Excel Community because I urgent need help from an Excel spreadsheet expert. what function or formula can I used to narrow(lookup) a specific expenses to a particular ...
- Nov 14, 2019
Skpenu505Here's a way to have the data validation list change depending on the dept number entered, as you requested. It uses named ranges for each departments codes, and then a VLOOKUP function nested in a CHOOSE function to select the appropriate range name.
Let me know if you have questions.
Ricardo Viana
Nov 13, 2019Iron Contributor
I am not sure if I got it correctly, if you want to sum the amount for all expenses with a specific fund code + department code (here is an example: =SUMIFS(G7:G19,C7:C19,701,B7:B19,B7) )