Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index and match across columns | Excel Discussion (Misc queries) | |||
Using INDEX & MATCH to search different columns | Excel Discussion (Misc queries) | |||
Index Match 2 columns 1 row | Excel Worksheet Functions | |||
Index Match for 2 columns and one Row | Excel Worksheet Functions | |||
Index/Match from multiple columns | Excel Worksheet Functions |