I need some help with what i believe should be a lookup expression but i may be incorrect.
Within excel/Google sheets it is pretty simple but I dont appear to be able to get it to work within appsheet. I use a combination of Lookup and If Statements.
I basically have a lookup table that has a number of rows with employee numbers on. then there are a number of columns with different values. The column to select will be based on another variable selected by the user. Basically there are two inputs from the user in excel to give the value.
here is the equation in google sheets that i use:
=VLOOKUP(‘Client Details’!B18,DayTable!$F$2:$P$24,IF(‘Client Details’!C10=“High”,2,IF(‘Client Details’!C10=“Medium”,3,IF(‘Client Details’!C10=“Low”,4)))))
I am trying to copy this into appsheet but I cant get it to work. i used a simple deref to begin with for employee numbers which was easy, when i then tried bringing in the high, medium, or low variable that didnt work.
The user will select a risk of either high, medium or low. they will then enter the employee numbers. The value returned will be one of 3 different columns (one for high, one for low, one for medium) for the row of employees they have selected.
Ive uploaded the lookup table in case that helps.
Ive tried using lookup but i cant get it to work
I hope that makes sense, any help would be greatly appreciated