LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Input sheet with INDEX formula

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
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
dragging the row contents of all the sheet to a Index sheet Narnimar Excel Discussion (Misc queries) 2 December 20th 08 06:04 PM
sheet index in a formula Mr T Excel Worksheet Functions 1 December 14th 07 03:44 PM
Index Indirect to input worksheet name and range name Native Excel Discussion (Misc queries) 1 March 19th 07 09:38 PM
input # on sheet 1, pulls all info for # from sheet 2 moochx5 Setting up and Configuration of Excel 1 July 19th 06 10:43 AM
INDEX, user input? chris w Excel Worksheet Functions 3 December 10th 04 06:07 PM


All times are GMT +1. The time now is 06:16 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"