Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Trying to pull data from one page to another in XL?
I have a chart with names in a and scores in b.
Using =lookup(name, a1:a5,b1:b5) I can get what I want it to do, BUT my list has to be sorted. My list is being auto generated based on 3different pages. So if I add a name on page 3 it doesn't know how to sort the data. So my question is, Is there a different command I should be using?
I'm trying to use the name in a square b4 on page1 to find the same name on page2 in column A, then pull the score in B that is aligned with the name to put into c4(where this equation goes!)
currently using =lookup(b4,page2!a1:a5, page2!b1:b5) but the list on page 2 is not sorted because it is just pulling names from page 3-5 I tried to have a multi nested if( with multi lookup( but I couldn't make it work on the different pages (I think the code was 9 lines long!) so it failed!
1 Answer
- IXL@XLLv 79 years agoFavorite Answer
=INDEX(B:B, MATCH(name,A:A,0)
Without knowing your sheet structure the above may not work as you say data is collected from various sheets.
