Lookup reference in another row referenced
Possibly this cannot be done in Smartsheet. I am trying to port over our drawing list coordination sheet from excel to Smartsheet.
The formula uses Lookup in Excel - actual revision number to find on the same row that number - then return the date of that column from the first row of the sheet.
The excel formula is as follows: =LOOKUP($D128,$H128:$BC128,$H$2:$BC$2)
My attempts have failed in SmartSheet.
Can we use LOOKUP to return the result of data from the same column on a different row?
From my research, there is a requirement to specify which column contains the information, can this be replaced by an argument?
I have attached the Excel Screenshot
Many thank for suggestions
Help Article Resources
Check out the Formula Handbook template!