Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match formula not returning correct values.
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My IF in Excel formula is not returning the correct value. | Excel Worksheet Functions | |||
Returning MULTIPLE values with Index and Match | Excel Discussion (Misc queries) | |||
MAX Function not returning correct value | Excel Worksheet Functions | |||
VLOOKUP not returning correct value | Excel Worksheet Functions | |||
Vlookup not returning correct value | Excel Worksheet Functions |