Ask Your Question

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

asked 2018-01-02 14:18:54 +0200

Roihan gravatar image

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.

edit retag flag offensive close merge delete


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?

Lupp gravatar imageLupp ( 2018-01-02 14:43:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-02 19:52:56 +0200

Jim K gravatar image

updated 2018-01-02 19:54:19 +0200

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


vlookup example

edit flag offensive delete link more


How do you think about the probable ambiguity?

Lupp gravatar imageLupp ( 2018-01-02 21:00:47 +0200 )edit

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

Jim K gravatar imageJim K ( 2018-01-03 18:51:48 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-02 14:18:54 +0200

Seen: 37 times

Last updated: Jan 02 '18