damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
Morning All.
I think this is some sort of lookup function but it needs to look up for some of the text within a cell rather than the entire contents.....for example
As you can see, cell C6 contains a manually entered string of text.
In cell I6 I need it to look at Sheet1 (in the same workbook), cell range B$6:B$100 and look for the text "Terracotta - helping hands". Assuming that for this example it finds that text in cell B54, I would want cell I6 to show the contents of Sheet1 cell C54
As mentioned before, its some kid of LOOKUP but the fact its only looking up part of the cell contents is what I've no idea how to do.
Hope this makes some sort of sense
Stay safe
D
I think this is some sort of lookup function but it needs to look up for some of the text within a cell rather than the entire contents.....for example
As you can see, cell C6 contains a manually entered string of text.
In cell I6 I need it to look at Sheet1 (in the same workbook), cell range B$6:B$100 and look for the text "Terracotta - helping hands". Assuming that for this example it finds that text in cell B54, I would want cell I6 to show the contents of Sheet1 cell C54
As mentioned before, its some kid of LOOKUP but the fact its only looking up part of the cell contents is what I've no idea how to do.
Hope this makes some sort of sense
Stay safe
D