Switch with lookup

[madelacruz]

Hi I'm new Here , Can someone help me with my formula, how can i get the value of student no and rfid from Student Master List? 

SWITCH(LOOKUP([_thisrow].[RFID],"Student Master List", "RFID", "STUDENT NUMBER"), "",student no, RFID)

switch looks good but its returning text and not the value. thanks in advance

[Suvrutt_Gurjar · Accepted solution]

perhaps this?

SWITCH(LOOKUP([_thisrow].[RFID],"Student Master List", "RFID", "STUDENT NUMBER"), "",student no, [RFID])

In general to get the values from the other tables, you may want to consider referencing between tables.

References between tables - AppSheet Help

[madelacruz]

OIC, so i just need to reference the student no so i can return its value. thanks bro

[Aurelien]

Hi @madelacruz 

---

@madelacruz wrote:

how can i get the value of student no and rfid from Student Master List? 

---

Here is the expression for returning the Student no after its RFID value:

LOOKUP([RFID],"Student Master List", "RFID", "STUDENT NUMBER")

You already have the RFID from what I read.

Please keep in mind that SWITCH() expression tests the output of the first part of your expression.

If you are looking to return a specific text when the searched value is not found, then you may want to use instead:

IF(
  ISBLANK(LOOKUP([RFID],"Student Master List", "RFID", "STUDENT NUMBER")),
  "RFID with no student no",
  LOOKUP([RFID],"Student Master List", "RFID", "STUDENT NUMBER")
)

For reference:

SWITCH() - AppSheet Help

LOOKUP() - AppSheet Help

ISBLANK() - AppSheet Help