CODEWITHSUNDEEP
excelexcel-formula
Kangaroo
Kangaroo

Reputation: 17

Find Exact Match in one Column and return text

I am trying to find a formula that could do the following for me:

I have my Column A showing either "In" or "Out", then I have a series of unique numbers in Column B, Column C I have some numbers gotten from Column B. I would like to find a formula where I could key in Column D.

This formula should first, find out if Column A is "In" or "Out", if Column A is "In", then search through the whole of Column C to see if the number in Column B has appeared in Column C or not, If it has, return Sold in the cell in Column D.

I tried with IF, VLOOKUP and Match function but could not find a suitable combination. Thanks!

enter image description here

Upvotes: 1

Views: 1029

Answers (1)

Steven Pomponio
Steven Pomponio

Reputation: 340

The following formula should achieve the desired output:

=IF(A2="In",IF(COUNTIF(C:C,B2)>1,"Sold","Unsold"),"")

Then click and drag it down for the rest of the records.

Upvotes: 1

Related Questions