if statement - Compare a single row with a column and extract the value from another column on the same row in Excel -

if statement - Compare a single row with a column and extract the value from another column on the same row in Excel -

so i'm looking formula or this:

i have 4 columns. b c d.

i have column (a) multiple values can have duplicates.

a1: a2: a3: b a4: c a5: c

i want compare each row column (b) has 1 of each value. b1 = a, b2 = b etc. value want extract column "d" in column "c". if a1 equals in column b, want extract value in column c on same row, column d.

so in d1 want value c1. in d2 want value c1 well. in d3 want value c2.

this seems work:

=vlookup(a1:a5,b1:c5,2,0)

entered array formula in d1:d5 using ctrl+shift+enter.

result:

excel if-statement