Hello,
Is there a formula I can put into a cell that will use another cell as a reference, find a match for that number on another sheet, go to the last cell with data in that row, but then return the data from cells to the left of that, ie: -1 or -2.
Sheet1:
<tbody>
reference data (12345)...