0

enter image description here

Hi all,

Is there an excel formula to print the values in Column A for values in Column C please? In order to obtain the Column A values use Column B.

For example

Name 5 in Column C, should print mjijij in Column D, based on Name 5 value Column B.

Regards,

JScriptBeginner_25
  • 65
  • 5
  • Simple INDEX/MATCH will do it. – Scott Craner May 16 '18 at 22:01
  • 1
    check out the answer here: https://stackoverflow.com/questions/48348889/excel-vlookup-vs-index-match-which-is-better?rq=1 while not a duplicate question, the answer will give you all you need to do this. – Scott Craner May 16 '18 at 22:03

1 Answers1

0

Use the formula on Column D1,

=INDEX($A$1:$B$11,MATCH(C1,$B$1:$B$11,0),1)

Change the range as per your record.

Hope this helps you.

Mubarak Abdullah
  • 55
  • 11