help needed with index match formula

[BigDumbRebel]

I've been producing a spreadsheet on excel and have used drop-down list
for data validation and need to use and index match formulae o
something similar in the cell "D103" to retrieve data from a list o
componenets i have entered. I have tried the formula
"=INDEX($A$2:$F$94,MATCH($C$103,$C$2:$C$94,0),MATCH($B$2,$A$1:$F$1,0))

my index is between A2 and F94 and would like it to look up the price
but the formulae i am using produces a "N/A" result.
all my components are in the "C" column.
Any help at all would be greatly appreciated.
If anyone feels they could help and is willing to perhaps look at m
file, please contact me.
Thanks.
(e-mail address removed)

Attachment filename: coursework.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=38585

 

[RagDyer]

Enter this in D103:
=VLOOKUP($C103,$C$2:$F$94,2,0)

Enter this in E103:
=VLOOKUP($C103,$C$2:$F$94,3,0)

Enter this in F103:
=VLOOKUP($C103,$C$2:$F$94,4,0)

Then select all 3 cells (D103:F103), and drag down to copy as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I've been producing a spreadsheet on excel and have used drop-down lists
for data validation and need to use and index match formulae or
something similar in the cell "D103" to retrieve data from a list of
componenets i have entered. I have tried the formulae
"=INDEX($A$2:$F$94,MATCH($C$103,$C$2:$C$94,0),MATCH($B$2,$A$1:$F$1,0))"

my index is between A2 and F94 and would like it to look up the prices
but the formulae i am using produces a "N/A" result.
all my components are in the "C" column.
Any help at all would be greatly appreciated.
If anyone feels they could help and is willing to perhaps look at my
file, please contact me.
Thanks.
(e-mail address removed)

Attachment filename: coursework.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=385855

 

[Guest]

The N/A# error comes up when Excel doesn't find a match. I notice that your Index table starts in column A, but your first match function is on column C. Could this be your problem? What is the cell range of the horizontal match array? the vertical match array? the data array

Good Luck
Mark Graesse
(e-mail address removed)

----- BigDumbRebel wrote: ----

I've been producing a spreadsheet on excel and have used drop-down list
for data validation and need to use and index match formulae o
something similar in the cell "D103" to retrieve data from a list o
componenets i have entered. I have tried the formula
"=INDEX($A$2:$F$94,MATCH($C$103,$C$2:$C$94,0),MATCH($B$2,$A$1:$F$1,0))

my index is between A2 and F94 and would like it to look up the price
but the formulae i am using produces a "N/A" result
all my components are in the "C" column
Any help at all would be greatly appreciated
If anyone feels they could help and is willing to perhaps look at m
file, please contact me
Thanks
(e-mail address removed)

Attachment filename: coursework.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=38585

 

[BigDumbRebel]

Thanks a lot , that helped after entering the formulae that you gave me
, much appreciated.