Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi again all:
I have Input sheet with two parts information, its first part related to Works sheet has no problem. But the second part related to Material sheet doesn't work correctly. Input sheet part two: A37:A69 Material Names(Text). B36:F36 Seller Names (Text). B37:F69 Material Price (Value). These are related to Materials Sheet which is like: A2:A34 Same Material's Names. B2:B34 Dropdown list of sellers. C2:C34 Respective seller price in Dropdown list cell. I used this =INDEX(Input!$A$37:$F$69,Match($A2,Input!$A37:$69, 0),MATCH($B2,Input!$36:$36,0)) Merely C2 price was shown correctly rest up to C34 with #REF. Could you instruct me please. Cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dragging the row contents of all the sheet to a Index sheet | Excel Discussion (Misc queries) | |||
sheet index in a formula | Excel Worksheet Functions | |||
Index Indirect to input worksheet name and range name | Excel Discussion (Misc queries) | |||
input # on sheet 1, pulls all info for # from sheet 2 | Setting up and Configuration of Excel | |||
INDEX, user input? | Excel Worksheet Functions |