Copy value from a B column to C1 where A = (certain value)

[Roihan]

Pretend that there are 3 columns : A, B, and C.
I need to copy the value from a B column to C1 where A value is blablabla.
It is something like COPY FROM B TO C1 WHERE A='blablabla.
Is it possible? If it does, how to do it, then? Thanks.

[Lupp]

Formulas don’t copy anything.
A selection (“SELECT B_content WHERE A_content = TheKey”) cannot be output to a single cell.
Do you only need the content of B corresponding with the first occurrence of the key in column A?

[jimk]

The function is VLOOKUP. Enter the following formula in C1.

=VLOOKUP("blablabla";A:B;2;0)

[Lupp]

How do you think about the probable ambiguity?

[jimk]

The question reads “copy the value,” so if that is accurate, then there is only one value for the key.