Assigning values to a row

Closed
cooldave1981 - Aug 10, 2015 at 02:47 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 10, 2015 at 03:30 PM
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



Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 10, 2015 at 03:30 PM
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
0