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!
What is the intended purpose of your expression?
I want pin code from multiple sheet.
area name to pincode
Everything about your expression is wrong. Why did you write it that way?
See also:
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |