Assigning values to a row

[Closed]
Report
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
Hello,

I have a row with descriptions in the adjacent cell
for example
a1 sam b1 happy
a2 Jessica b2 sad
a3 max b3 angry

then in row c it says
c1 max
c2 max
c3 Jessica
c4 max
c5 max
c6 Jessica

How do write a formula where it checks if the value in a "c" cell matches a value in an "a" cell and then copies the description listed in the adjacent b row into the adjacent d row for the c cell I am looking at

So it will return

D1 happy
d2 happy
d3 sad
d4 angry
d5 angry
d6 sad



1 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
Cooldave1981, Good afternoon.

Using your example try to use this formula:

D1 --> FORMULA

=VLOOKUP(C1 , $A$1:$B$3 , 2 , FALSE)
Copy it down.

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão