Please help which part wrong

[Mr_Smile]

SELECT(DELHI[PINCODE], ([AREA NAME] = [_THISROW].[AREA])) AND SELECT(UP[PINCODE], ([AREA NAME] = [_THISROW].[AREA])) AND SELECT(BIHAR[PINCODE], ([AREA NAME] = [_THISROW].[AREA]))

only first function working. second and third not working why!

[Joseph_Seddik]

What is the intended purpose of your expression?

[Mr_Smile]

I want pin code from multiple sheet.

area name to pincode

[Steve]

Everything about your expression is wrong. Why did you write it that way?

See also:

help.appsheet.com

AND()

Are all true?

help.appsheet.com

SELECT()

Gather column values from row in table or slice