I was surprised to search and find no results for vlookup. This is a super common “programming” function in Excel so I figured there must be a thunkable equivalent. Can someone assist how to do this?
In Excel (in case you don’t know)
In Excel the function works like this. I have 2 columns. In the first column could be, for example, a list of the 50 states. In the second column would be their corresponding capitals. So when I input “Delaware” into the vlookup, it finds Delaware and returns “Dover”. This is an overly simplistic example, but, you get the idea.
Just not sure how to proceed and because my game was first built in excel … I’ll have to convert a lot of vlookups into thunkable code.