Some sort of lookup function?

damian_r_Home

Board Regular
Joined
Jan 8, 2005
Messages
231
Office Version
  1. 365
  2. 2007
Platform
  1. 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
1628585318433.png


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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
TBH, what you have done so far is just perfect and it is much appreciated.

I am going to try a tweak of your formula for another idea I have ... its likely I don't have the skill set to do what I'm thinking so I might be back on here in a couple of hours....
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top