Get COLUMN and Update

[Mayank1]

When i get Column (Job No) using google sheets then i want to set a variable to the contact Number of the same row as the Job No

[Ramon]

show your blocks

[Taifun]

@Mayank1

i want to set a variable to the contact Number

What exactly are you trying to do? Any example of how the contact number then looks like?
This sounds like you want to send an update statement to the spreadsheet...

Spreadsheet component. Example. Google Sheets

(added to FAQ)

Taifun

[ABG]

Try a Filtered lookup of contact number by job number.

[Mayank1]

How to do that?

[ABG]

(based on the column numbers in your sample sheet image)

[Mayank1]

Thank You

can u explain the (,gotFilterResult) if possible

[ABG]

The GotFilterResult receives TWO lists:

• returnRows is a list of the row numbers of the rows in returnData, needed if you want to update those rows later
• returnData is a matching list of data rows from that sheet that passed the Filter test, with the cell contents of each row. It is a list of lists (a table).