Discussion
Basically I need help with a formula, think it would be an array.
The formulae needs to identify a company and a Quarterly period from drop down selection and pull that relevant information from another sheet.
Select ""Supplier"" then ""Quarter"" then formula will look at relevant table.
The formulae needs to identify a company and a Quarterly period from drop down selection and pull that relevant information from another sheet.
Select ""Supplier"" then ""Quarter"" then formula will look at relevant table.
mickythefish said:
Basically I need help with a formula, think it would be an array.
The formulae needs to identify a company and a Quarterly period from drop down selection and pull that relevant information from another sheet.
Select ""Supplier"" then ""Quarter"" then formula will look at relevant table.
Perhaps a SUMIFS function would work?The formulae needs to identify a company and a Quarterly period from drop down selection and pull that relevant information from another sheet.
Select ""Supplier"" then ""Quarter"" then formula will look at relevant table.
You need to give more detail in what you're trying to do, such as how your data structured and what you're trying to extract from the data.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff