View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin Jason Morin is offline
external usenet poster
 
Posts: 63
Default 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.
.