Converting from google sheets to excel

Occasional Contributor

Hello! My company recently did a complete changeover from google to microsoft. There is a very useful document that wasn't translating the formulas correctly. There is no "error" response but it will not calculate. Can anyone help, this is an example:



10 Replies


The last row number of two ranges is missing. Try




If the data on the sheet you're referring to has more than 1000 rows, adjust the number 1000 in the formula accordingly (both times)

Unfortunately, that did not work. Does the formula require "MATCH" to be "XMATCH"?


That formula DOES work - I have tested it. But it returns a blank if there is no match.


Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

I can put it through onedrive, if that works


Please do.

may i have your email?


hans dot vogelaar at gmail dot com

I have sent the link
Thank you!!!!
best response confirmed by Sergei Baklan (MVP)


The formula in C3 should be




Fill down and to the right. And the formula in C24 should be




Also fill down and to the right.

That worked perfectly. Thank you!!