J
jaybird2307
I have a range of data where I need to find the value in a column by
narrowing down with two different criteria.
These are my column titles:
Account Number
Year
January
February
March
etc.
I need to lookup down the account number column and return the value
for March where the Year is 2005. In other words, on another
spreadsheet, I have a list of accounts and I'm trying to search my data
range and find the March value where the year is 2005.
I'm not sure how to combine DGET, VLOOKUP, MATCH, and/or INDEX to
accomplish this.
Thanks for your help.
narrowing down with two different criteria.
These are my column titles:
Account Number
Year
January
February
March
etc.
I need to lookup down the account number column and return the value
for March where the Year is 2005. In other words, on another
spreadsheet, I have a list of accounts and I'm trying to search my data
range and find the March value where the year is 2005.
I'm not sure how to combine DGET, VLOOKUP, MATCH, and/or INDEX to
accomplish this.
Thanks for your help.