I am running a vlookup function in Mac M1 Excel. This code used to work find on my Intel Mac and now fails. Have tried running the function with the same parameters directly in the spreadsheet and works perfectly find. The range object used in the VBA has the correct values when I look in the Object inspector. Any know issues with this function for VBA on Apple Silicon?
