Hi
I have a problem with INDEX/MATCH formula. I have many scenarios writen in second sheet named 'source'. Single scenario has 3 rows with same number of scenario. Column A and B are source for this index/match formula
this formula i have in C2
<tbody>
</tbody>
I have another sheet with name SOURCE where i have data related to this INDEX MATCH formula. It works fine, but only for the first scenario, which is under number 1. If i put scenario number 1 in any other cell (like in cell c11) formula work great.
But when i wanna other data from othe scenarios like scenario 2 or 3 i get [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! If i put scenario number 2 or 3 in cell c2 i get [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] !
Where or what is problem here ?
I have a problem with INDEX/MATCH formula. I have many scenarios writen in second sheet named 'source'. Single scenario has 3 rows with same number of scenario. Column A and B are source for this index/match formula
this formula i have in C2
This formula is also in whole C column.IF($b2="";"";INDEX(Source!D:D;MATCH($b2;Source!C:C;0);MATCH($a2;Source!B:B;0)))
Scenario number | CROP | Name |
1 | Cabbage | Redma F1 |
1 | Lettuce | Decision F1 |
1 | Onion | Tamara F1 |
2 | Peppers | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! |
2 | Tomato | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! |
2 | Potato | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! |
3 | Lettuce | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! |
3 | Tomato | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! |
3 | Onion | [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! |
1 | Cabbage | Redma F1 |
1 | Lettuce | Deciosion F1 |
1 | Onion | Tamara F1 |
<tbody>
</tbody>
I have another sheet with name SOURCE where i have data related to this INDEX MATCH formula. It works fine, but only for the first scenario, which is under number 1. If i put scenario number 1 in any other cell (like in cell c11) formula work great.
But when i wanna other data from othe scenarios like scenario 2 or 3 i get [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] ! If i put scenario number 2 or 3 in cell c2 i get [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ref]#ref [/URL] !
Where or what is problem here ?