CODEWITHSUNDEEP
excelexcel-formulaexcel-2013
howzat
howzat

Reputation: 49

Simple Search Function in Excel

Sorry for the noob question.

In Excel 2013, I have three columns.

Column A has the data that I would like to search for in Column B.

Column B contains a list of data.

Column C contains the data that states whether the data in Column B is of 'Yes' value or 'No' value.

My question is this: Is there a function or a way in Excel that can search for the data in Column B with the data in Column A as the search criteria?

The data in Column A is already in Column B, I just need to know what the data in Column C is.

ColA    ColB    ColC
6712XD  6700XD  Yes
6713XD  6701XD  Yes
6714XD  6702XD  Yes
         ....   Yes
        6712XD  Yes
        6713XD  Yes
        6714XD  Yes

Any help is much appreciated, let me know if I need to provide any more info.

Upvotes: 0

Views: 107

Answers (2)

howzat
howzat

Reputation: 49

Found the answer from Lookup using table with separated columns, it's:

=INDEX(AF:AF,MATCH(P930,Q:Q,0))

Thanks for your help :)

Upvotes: 0

Slai
Slai

Reputation: 22866

You can try this formula in cell D2:

= IF( COUNTIF( B:B, A2 ), C2, "" )

COUNTIF( B:B, A2 ) returns a number of how many times the value of cell A2 is found in column B, C2 is the result value if found, and
"" is the result value if not found.

Upvotes: 1

Related Questions