How do i get range of address in excel based on certain condition?
Answers
Answered by
0
extremely right & extremely down
Answered by
0
=INDEX(YourRange, MATCH(A1, FirstColumn, 0), 2)
Where YourRange is the range of your table in your example and FirstColumn is column A in your table. A1 is the cell with the item you want to look up. The zero in the MATCH function is there to find the exact match and the 2 is the column you want to pull back. So 2 for B, 3 for C etc..
I think of INDEX as a game of Battleships the first parameter is your playing board, the second parameter is how many rows down and the last parameter is how many columns across.
i hope it helps u
@#champ
mark my answer as brainliest
Similar questions
Science,
7 months ago
English,
7 months ago
Math,
7 months ago
Physics,
1 year ago
Environmental Sciences,
1 year ago
Environmental Sciences,
1 year ago