"300" notfound?
 

=INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11 ) is my formula but
"numbers' such as "300" cannot be located? If I add a letter to the number
(i.e. "300E") it works fine. I am setting this up to (A) search a part number
on a different worksheet (within same workbook) and (B) to identify then a
value for a horizontal column ref. The "HELP" screen shows me a "MATCH"
formula is capable of picking up "numbers" as well as "letters" in an array
formula so if anyone can assist I would be forever grateful :-)

"300" notfound?
 

Try removing the quotes from around "300".

=INDEX(all!A1:K1338,MATCH(300,all!A1:A1338,0),11)

Biff

"BrettM" wrote in message
...
=INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11 ) is my formula but
"numbers' such as "300" cannot be located? If I add a letter to the number
(i.e. "300E") it works fine. I am setting this up to (A) search a part
number
on a different worksheet (within same workbook) and (B) to identify then a
value for a horizontal column ref. The "HELP" screen shows me a "MATCH"
formula is capable of picking up "numbers" as well as "letters" in an
array
formula so if anyone can assist I would be forever grateful :-)

"300" notfound?
 

In your table, 300 is probably formatted as a number. Match treats "300" and
300 differently.

Try:
=INDEX(all!A1:K1338,MATCH(300,all!A1:A1338,0),11)

"BrettM" wrote:

=INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11 ) is my formula but
"numbers' such as "300" cannot be located? If I add a letter to the number
(i.e. "300E") it works fine. I am setting this up to (A) search a part number
on a different worksheet (within same workbook) and (B) to identify then a
value for a horizontal column ref. The "HELP" screen shows me a "MATCH"
formula is capable of picking up "numbers" as well as "letters" in an array
formula so if anyone can assist I would be forever grateful :-)