I am looking for a formula to refer to an entire variable row from another sheet. Sheet 1 is a list of truck numbers with the dates of the their last work. Sheet 2 is pulling data from another sheet in the company which lists all the trucks in column C and the following columns […]

Categories

## How to refer to a variable row from another sheet

- Post author By How To
- Post date April 4, 2020
- No Comments on How to refer to a variable row from another sheet

- Tags 1/(Sheet2!123:123), any help would be appreciated., COLUMN(Sheet2!1:2000))) The above returns the column number of the last column with a value. The problem is I don't know how to make row#123, I am looking for a formula to refer to an entire variable row from another sheet. Sheet 1 is a list of truck numbers with the dates of the th, rather than manually scrolling through the page to see the last date of each truck. This is what I have so far... =ArrayFormula(LOOKUP(2, there is only a value in the date if the truck worked that day representing the diary page number. I am trying to create a formula which show