Find and display result

[conorhegarty18]

Hi Guys,

I would like to search a column to find a certain text and then display the result from another cell and display it in another.

eg -

Search Column A for "blue" and If text in column A = Blue then display result from B1

Does that make sense.

There will only ever be one colour

Basically i am looking to load the amount of stock of an item from another worksheet.

[Richard Buttrey]

Hi,

Welcome to the forum.

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.