Forum Discussion
index an array and match from array
i am trying to find a formula to would allow me to search an array and find the data matches the data from another array. for instance my Array A is formatted like EE01123 EEM02123 EE10123 and Ar...
Without dynamic arrays, your best option may be to extract the number portion of the string first with flash fill (Type in the desired return for the first item, press enter, then press ctrl+E). Then you can run INDEX-MATCH off the cleaned up numbers:
Ok i see what you are doing here and it works for what i am wanting to do except i need it to list the list A item not the list B option. in your example i need row E to show me the items in row C that match the criteria of row G.
i do apologize this is my first time posting for help.
i do apologize this is my first time posting for help.