I have a maintenance tracker in Google Sheets for lighting fixtures. One column is a type of fixture "B", the column adjacent is the problem "C". I'd like to find specific fixtures by name and copy the adjacent data into a different sheet. Basically, I need to find a specific cell and populate a different cell with adjacent data of that cell.
-
question is not clear. share a copy of your sheet with example of desired output– user0Jul 13, 2019 at 12:41
-
i've clarified, also, here is my link docs.google.com/spreadsheets/d/…– Kevin ArsenijevicJul 13, 2019 at 13:01
Add a comment
|
1 Answer
try simple
VLOOKUPwith exact and partial matches and outputting 1st and 2nd adjacent cells=ARRAYFORMULA(IFERROR(VLOOKUP(""&B2:B, {REGEXEXTRACT(Maintenance!B8:B, TEXTJOIN("|", 1, B2:B)), Maintenance!C8:D}, {2, 3}, 0)))
