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
formula or function in excel 2007?
I have 2 columns of lists, one with the names (Names1) and second the corresponding value (Value) om one sheet, and on the other I have more names (Names2) including these. I want a formula or some kind of function in excel that if Name1 matches Name2 then insert the Value of Name1 there, could you help?
Thank you in advance!
3 Answers
- 1 decade agoFavorite Answer
Sheet 1.......................Sheet 2
(A)...........(B)...............(A).................... (B)
Name 1....Value 1.........Name 2......Formula Value
Given that Name 1 is in column A, Value 1 is in colunn B, and the same on the other sheet, you can use the index match formula to pull in the first matching value for any names found in both sheets.
In B2 of sheet 2, use this formula:
= INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0))
This formula looks for values in column B of sheet 1, and using the current matching name in column A of sheet 2, it finds the first row that the name is located in on sheet 1. Using this row number, it pulls in the corresponding value.
Source(s): Trial and error - Anonymous4 years ago
attempt help. click the down arrow beside the capital sigma (aka the vast E, or summation sign). opt for "greater purposes" this brings up a checklist of all purposes by capacity of classification. there is a lot, so no-one desires examples of all of them, fairly the unusual statistical and financial purposes. help includes short occasion.
