Index/Match for 2 columns?
With plant name in F1 and size in G1, use:
=INDEX(C1:C20,MATCH(F1&G1,A1:A20&B1:B20,0))
Array-entered, meaning press ctrl + shift + enter.
HTH
Jason
Atlanta, GA
-----Original Message-----
I am looking for a way to match info in Column A AND
Column B, then return
the appropriate value from Column C from the same row.
Column A is "plant names" and could have 4 rows
of "Holly". Column B is
"size" and would distinguish the 4 hollies by size: 1g,
5g, 7g, 10g. I want
a formula that will look up the plant name, find the
correct size, and return
the value in that row from Column C ("price").
Column A is not alphabetized, and has 450-500 rows.
Column B repeats the
same possible sizes throughout the column. (1g, 5g, 7g,
10g)
Is there a formula for that? Please help.
.
|