"300" notfound?

B

BrettM

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

Biff

Try removing the quotes from around "300".

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

Biff
 
J

JMB

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