I have a spreadsheet I am trying to match like model numbers, however, my
formula is returning #N/A, or if there is a match it returns some number. I
am using =match(A2,D$2:D$24360). Thanks for any help

A B C
D
Model # Serial # Model
32HL67 AM339004740 #N/A C2405
32HL67U AM379011491 #N/A TM233XC
32HL67U AM37010883 #N/A TM243XC
32HL67U AM37021155 #N/A PT46DL10

First, since you're matching on text, you may want to look for an exact match:

=match(a2,d$2:d$24360,0)

And =match() returns the row number in that range for the first cell that
matched values. If there is no match, you get the error.

Maybe you wanted an indicator to show if there was a match or not:

=isnumber(match(a2,d$2:d$24360,0))
will return True if there's a match, False if there is no match.



pm wrote:

I have a spreadsheet I am trying to match like model numbers, however, my
formula is returning #N/A, or if there is a match it returns some number. I
am using =match(A2,D$2:D$24360). Thanks for any help

A B C
D
Model # Serial # Model
32HL67 AM339004740 #N/A C2405
32HL67U AM379011491 #N/A TM233XC
32HL67U AM37010883 #N/A TM243XC
32HL67U AM37021155 #N/A PT46DL10

--

Dave Peterson