Forum Discussion

StuartValueTyre's avatar
StuartValueTyre
Copper Contributor
Oct 18, 2019

Match Formula not working

Hi     I have a problem when open a spreadsheet that should contain the following formula   =MATCH(F284&E284,$'Mailman''s Route'.A$1:$'Mailman''s Route'.A$500&$'Mailman''s Route'.B$1:$'Mailman'...
excel
Formulas and Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 18, 2019

StuartValueTyre

 

Hi,

 

Please let us know what you're trying to do, and provide a sample of the data.

Anyway, the second formula is an array formula that needs Ctrl+Shift+Enter to return the value, not only Enter.

 

Regards

  • StuartValueTyre's avatar
    StuartValueTyre
    Copper Contributor
    Oct 18, 2019

    Haytham Amairah 

    Thank you that has worked for me, this 64 year old brain is still catching up with this new computer stuff.