Hi I'm trying to create a formula that would identify part of some text in a cell from a range of cells (column) in another spreadsheet and once it identifies the text insert the text from the adjacent cell.
I thought the formula =LOOKUP(A3,'Sheet1'!$B3:$B100,$C3:$C100)
Where A3 contains the text and the cells within the range B3:B100 will contain part of the text in A3 and the text in the cell adjacent to the cell containing the text of interest (range C3:C100) will then appear in the cell I put the formula in.
Hope this makes sense.
Bookmarks