Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table that looks like this:
January February Currency 1 Text 1 1.1000 2.1000 Text 2 1.2000 2.2000 Text 3 1.3000 2.3000 Currency 2 Text 1 1.1200 2.1200 Text 2 1.2200 2.2200 Text 3 1.2300 2.2300 On sheet 2, I want cell B1 to return 2.2000 if I have Currency 1 in cell A1, Text 2 in cell A2, and February in cell A3. I tried index/match but I'm struggling due to the fact there are 3 parameters. Also, column A of the data table has blank cells. This table is emailed to me weekly and is rather large. Is there a way to make a formula work without having to fill in the blank cells in column A each time I receive it? Thanks, Claudia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Max index / match question | Excel Discussion (Misc queries) | |||
Index & Match Question | Excel Worksheet Functions | |||
Index / Match Question | Excel Worksheet Functions | |||
Index/Match question Need help! | Excel Worksheet Functions |