Simple Column + Row = ? Problem..... I think! Im not even sure where to start wi
ID: 3564972 • Letter: S
Question
Simple Column + Row = ? Problem..... I think!
Im not even sure where to start with thiss...
I have two spreadsheets one called DATA and the other called REPORT. When I enter variables in the two green cells of the REPORT spreadsheet I need it to extract the informaation from the DATA sprreadsheet and fill in the yellow cell in the REPORT spreadsheet.
What formula should I use?
Please keep in mind that these clips are just tiny pieces extracted from much larger spreadsheets, I am trying to learn the principles so I can apply them to the larger spreadsheets.
Any and all help is greatly appreciated!
Thanks
Simple Column + Row = ? Problem..... I think! I½m not even sure where to start with thiss... I have two spreadsheets one called ½DATA½ and the other called ½REPORT½. When I enter variables in the two green cells of the REPORT spreadsheet I need it to extract the informaation from the DATA sprreadsheet and fill in the yellow cell in the REPORT spreadsheet. What formula should I use? Please keep in mind that these clips are just tiny pieces extracted from much larger spreadsheets, I am trying to learn the principles so I can apply them to the larger spreadsheets. Any and all help is greatly appreciated! ThanksExplanation / Answer
Use following formula -
=INDEX([Data.xlsx]Sheet1!$B$3:$K$5,MATCH(A3,[Data.xlsx]Sheet1!$A$3:$A$5,0),MATCH(B3,[Data.xlsx]Sheet1!$B$2:$K$2,0))
If tab name is not Sheet1 in Data.xlsx, please replace Sheet1 appropriately.
To make formula work, Data.xlsx needs to be opeen.
If you want that formula should work even wheen Data.xlsx is closed, then yoou have to give full path like belo?w -
=INDEX('C: emp[Data.xlsx]Sheet1'!$B$3:$K$5,MATCH(A3,'C: emp[Data.xlsx]Sheet1'!$A$3:$A$5,0),MATCH(B3,'C: emp[Data.xlsx]Sheet1'!$B$2:$K$2,0))
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.