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