Hi all
I am attempting to reference cell values from another sheet, but to be able to check a certain sheet depending on criteria of cell A1 - but I am getting myself in knots and presumably missing an important part:
cell A1 = "2020" (check 2020 Sales Data)
cell A1 = "2021" (check 2021 Sales Data)
I feel that I have sorted this part ^
Once sheet is referenced, I am looking for a specific row (retailer name) that is displayed in A4
cell A4 = "Tesco"
I feel I have sorted this part too ^
The last part, I would like to display the cell value of a given week number that is displayed in B3
cell B3 = 1 (for week1 on the given sheet)
=IFERROR(MATCH($A4,INDIRECT("'"&$A$1&" Sales Data Table'!$A:$A"),0),MATCH("Week"&$B$3,INDIRECT("'"&$A$1&" Sales Data Table'!$2:$2"),0),"")
this causes an error, but I can't figure out how to sort it. been watching lots of online tutorials but I am still not getting it to work.
Any help/advice will be much appreciated
I am attempting to reference cell values from another sheet, but to be able to check a certain sheet depending on criteria of cell A1 - but I am getting myself in knots and presumably missing an important part:
cell A1 = "2020" (check 2020 Sales Data)
cell A1 = "2021" (check 2021 Sales Data)
I feel that I have sorted this part ^
Once sheet is referenced, I am looking for a specific row (retailer name) that is displayed in A4
cell A4 = "Tesco"
I feel I have sorted this part too ^
The last part, I would like to display the cell value of a given week number that is displayed in B3
cell B3 = 1 (for week1 on the given sheet)
=IFERROR(MATCH($A4,INDIRECT("'"&$A$1&" Sales Data Table'!$A:$A"),0),MATCH("Week"&$B$3,INDIRECT("'"&$A$1&" Sales Data Table'!$2:$2"),0),"")
this causes an error, but I can't figure out how to sort it. been watching lots of online tutorials but I am still not getting it to work.
Any help/advice will be much appreciated