Regenerate Schema not identifying column code

[jonoooooo]

Hello!

I am trying to convert a spreadsheet into an app on appsheet. Most of the columns that generate with Regenerate schema are being done correctly; dropdown boxes are staying the same, columns with code are being converted to multi-column formulas. One column refuses to convert to a multi column formula code. Appsheet identifies it as an enum category.

This is the code in the column: =IF(C2="", "", IFERROR(VLOOKUP(C2, 'Student Names'!$A$3:B, 2, FALSE), "Name not found")) 

(It searches another sheet for a member number, depending on the name that is selected from a dropdown box)

Another one of my columns has very similar, cross sheet code and works fine, so I am confused as to why this specific column isn't working. Any help would be great!

EDIT: I realised it was because of VLOOKUP. The problem is now solved.

[WillowMobileSys · Accepted solution]

Could you reply to your post and then mark it as a solution so this is removed from the open list of Q&A items?