Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
That works perfectly! Thank you so much!
Excel- Pull Data from Multiple Sheets Based on Cell Criteria
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have a sheet that has multiple tabs. One tab is a summary tab and on this sheet I would like to pull data from other sheets. This is the Summary Sheet.
Another tab is titled "Doubles". Based on the name in Column A, I would like to pull the percentage in Column B and fill it in on the Summary Tab above for the correct person. The important part is that it pull the data based on the name so if the names get out of order then the percentage is still for the correct person.
There are additional sheets, but if I know how to pull from one sheet I can apply it to the others. Essentially there are a variety of sheets and I want to pull the score from each sheet but make sure to apply the percentage to the correct person. Can anyone please advise on the formula I would use to pull this data from different sheets? Thank you in advance!
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
6 answers
Sort by: Most helpful
-
Anonymous
2020-02-11T21:29:51+00:00