Excel for Mac conditional matching statement

by BEN   Last Updated October 15, 2018 06:01 AM

In Excel for Mac.

What I am trying to do is create a formula in cell A13 that will take a value from cell A1 and look for a match from a a list of multiple values from a list (column a) from tab b. If the value of A1 matches a value in column a from tab 2, then I want A13 to hold the value from the cell adjacent to the cell that A13 is a match for (from column A on tab 2).



Answers 1


=INDEX(Sheet2!B:B,MATCH(Sheet1!A1,Sheet2!A:A,0))
p._phidot_
p._phidot_
October 15, 2018 05:59 AM

Related Questions





No Startup folder in Microsoft Office for Mac 2011

Updated April 07, 2017 08:01 AM