1

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.

2

1 Answer 1

0
  • try simple VLOOKUP with 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)))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.