LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Double Match formula...

to get the idea here is what I have:


2-SIDED POCKET 140x200 0,0040 IZRADA RUKOHVATA
CHAMBORD 140x190 0,0071 IZRADA RUKOHVATA
2-SIDED POCKET 140x200 0,0025 REZANJE
CHAMBORD 140x190 0,0035 REZANJE

so this is on one sheet together (there are more of this operations like
"IZRADA RUKOHVATA" and "REZANJE" but you get the idea). Now I want on a new
sheet to create a selection where I select model - CHAMBORD 140x190 and
operation - REZANJE to get value of 0,0035. But also when I choose different
operation for CHAMBORD 140x190 like "IZRADA RUKOHVATA" to get value of
0,0071.

I know only how to do with one MATCH function. With two MATCH functions I
can get anything...

please help


 
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
double axis, double problem (i hope only to me) kitcho Charts and Charting in Excel 1 December 30th 06 12:52 AM
double match formula Todd Excel Worksheet Functions 2 November 7th 06 03:24 AM
Double and Multiple Lookup Using the MATCH Function Charles793 Excel Worksheet Functions 0 May 11th 06 01:46 PM
How do I display more than one match in a Index/Match formula? Trish Excel Worksheet Functions 0 September 26th 05 10:21 PM
dynamic, double vlookup, match, index, dget?? different workbooks Leslie Excel Worksheet Functions 11 June 27th 05 09:45 PM


All times are GMT +1. The time now is 07:50 AM.

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"