LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 32
Default Index/Match question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Max index / match question NBVC[_5_] Excel Discussion (Misc queries) 1 June 23rd 09 01:39 PM
Index & Match Question Iriemon Excel Worksheet Functions 2 February 3rd 09 07:17 PM
Index / Match Question carl Excel Worksheet Functions 1 December 24th 08 02:16 PM
Index/Match question Need help! Brian H Excel Worksheet Functions 5 October 11th 05 01:46 AM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"