0

I need a function to match the value entered into C1, to Search A:A, but show the value in the cell B:B (to the right).

The valve will be seen in D1 (where the function will be entered).

Gary's Student
  • 95,722
  • 10
  • 59
  • 99
Brad Holloway
  • 1
  • 2
    VLOOKUP is what you want. – Scott Craner Sep 15 '16 at 18:33
  • 2
    I'm pretty sure you would want either [`Vlookup()`](https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1) or [`Index/Match`](https://www.deskbright.com/excel/using-index-match/). [What have you tried](https://stackoverflow.com/help/how-to-ask)? – BruceWayne Sep 15 '16 at 18:34
  • 1
    so I guess no one cares about the valve in the title – Slai Sep 15 '16 at 18:43

1 Answers1

1

Here is a typical VLOOKUP() solution:

=VLOOKUP(C1,A1:B20,2,FALSE)

enter image description here

Gary's Student
  • 95,722
  • 10
  • 59
  • 99