Forum Discussion
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'...
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
Thank you that has worked for me, this 64 year old brain is still catching up with this new computer stuff.