Forum Discussion

Rob__James's avatar
Rob__James
Copper Contributor
Nov 25, 2023

need help using header reference to pull data from worksheet

Hello everyone, thanks to those who take a moment to read this.   I might be overthinking but I'm trying to setup a Master Inventory style sheet.   Using date format as yyyymmdd or 20231125 if in...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Nov 25, 2023

Rob__James 

You can use the INDIRECT function for this purpose. Since I don't know what the sheets for the individual dates look like, I'll provide an example. In B3:

 

=SUMIFS(INDIRECT("'"&B$2&"'!$F$1000"), INDIRECT("'"&B$2&"'!$A$1000"), $A3)

 

This sums the quantities in column F on the other sheet for the rows where column A contains the product in A3 ("Nails").

This can be filled down and to the right.

Rob__James's avatar
Rob__James
Copper Contributor
Nov 25, 2023

Hi HansVogelaar ,

 

Thank you for the suggestion.   The data sheets are very similar to the master sheet, same row heading and then values based on the inventory count.

 

I'm just wanting to pull the inventory count but use the column heading, maybe a vlookup would work better.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 25, 2023

    Rob__James 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources