If Cell = from Column 1 to display text same row from column 2?

[pixeldusk]

Hi there. This is my first question and is the first instance I can’t find the answer. So I’ll try to explain as best I can.

I have been using SUMPRODUCT to Match what is in column A to Column B based on what is in a certain Cell.
The idea is if the cell matches something from the first column then it displays the text from the second in the same row.

I found a way to do this with numbers but not with text:
=SUMPRODUCT(V3:V23=AT14,W3:W23)

I don’t need to SUM several instances, just Match A1 to B1:V20 (say B14) and display a match from C1:20 (C14)

It’s challenging to find an answer for this as I don’t know what to search for. Thank you for taking the time to read my question and please reply if you know the function/s that I need.

Cheers

[anon73440385]

just Match A1 to B1:V20 (say B14) and display a match from C1:20 (C14)

Is this a typo and it should read:

 just Match A1 to B1:B20 (say B14) and display a match from C1:20 (C14)

(V20 vs. B20)
?

[pixeldusk]

Yeah The V is a typo. Appologies for that

[anon73440385]

Hello,

try

=OFFSET($C$1;MATCH(1;B$1:B$20=A1;0)-1;0;1;1) --or–
=VLOOKUP(A1;B$1:C$20;2;0)

[pixeldusk]

VLOOKUP works great and I can use it for more than 2 columns. Thanks!

[anon73440385]

If the answers works for you, please consider to click the check mark () next to the answer. Thanks in advance …