Return to a wrong value when using index and match formulas

freyafan

When using the index and match formulas, the return value was correct before but when I refresh the search sheet then the final result start to be wrong and the same even the search value is not the same. Can anyone help to check and advice?

Here is an example:

formulas =INDEX({MMX-FOR PROTO TRACKER Range 1}, MATCH([STYLE#]@row, {MMX-FOR PROTO TRACKER Range 2}))

For example, the search value is style#, what I what is to get the correct style name which should be "U NK FLY CAP US CB SWDC 2" but somehow the return value is "U J CLUB CAP US CB FLT ESS"

BELOW IS THE MMX-FOR PROTO TRACKER SHEET:

BELOW IS THE RETURN VALUE SHEET:

Bassam Khalil

Hi @freyafan,

Try to use Index/Collect formula the following is a sample i test it :

=INDEX(COLLECT({MMX-FOR PROTO TRACKER Range 1}, {MMX-FOR PROTO TRACKER Range 2}, [STYLE#]@row), 1)

Here is a screenshot shows the result:

the database sheet

the return data sheet ( with formula )