Pull text X number of rows/Y number of columns away from cell
I have an Excel sheet (Home and Business 2024) that I'm trying to collect some information from to turn into a flat file. The file looks something like this.
I have a list of all the vendor IDs in a second sheet, and I want to be able to say "Find [vendor ID], go one row down, and go two cells to the right" to find the Vendor Name, for example.
I have tried working with the OFFSET() formula, but I'm getting thrown off by trying to make the first argument of OFFSET jump from 101 on the first row to 102 on the second row
Like this, but instead of Sheet1!B1, I want to be using Sheet2!B2 (101) to look up the location Sheet1!B1 as the OFFSET reference. That way when I drag it down one, it would use Sheet1B3 (102) to look up the location Sheet1!B7.
I was trying to play around with CELL("address") but not having any luck. Would appreciate any help you can offer!
ETA: There's also not always a consistent number of rows between e.g. Vendor 101's Legal Name and Vendor 102's legal name, which is why I want to offset from the Vendor ID.
[link] [comments]
Want to read more?
Check out the full article on the original site