=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 :-)

Try removing the quotes from around "300".

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

Biff

"BrettM" <(E-Mail Removed)> wrote in message
news:B17D4A9A-33E7-4F87-AA3F-(E-Mail Removed)...
> =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 :-)

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 :-)