For example, I want to find "138000" in column M of another spreadsheet, and return the value in column H on the spreadsheet. I thought "=offset(VLOOKUP(A1,'105'!M:M,1,false),0,-5)" would work, but it doesn't. Thanks.
For example, I want to find "138000" in column M of another spreadsheet, and return the value in column H on the spreadsheet. I thought "=offset(VLOOKUP(A1,'105'!M:M,1,false),0,-5)" would work, but it doesn't. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks