I have a vlookup in my source Excel that shows the correct result in Excel but in AppSheet just shows 0 for all records. I do have an IFERROR in front of the vlookup also to tidy things up.

The formula I see in AppSheet isn’t the same as I have in Excel?