Give results if a value in a column matches

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I would like Column L on sheet 1 to display the data in Column O on sheet 3 if the data in column A on sheet 1 matches the data in column c in sheet 3. For example, both sheet 1 and sheet 3 display 5 digit numbers that match but are in different order, and on sheet 3 in the same row as the 5 didgit number is text that I would like to display on sheet 1.

Sheet 1 Sheet 3
Column A Column L Column C Column O
(Cell 1) 58463 ? (Cell 1) 14875 YES
(Cell 2) 74852 ? (Cell 2) 58463 NO
(Cell 3) 14875 ? (Cell 3) 74852 YES

Since in Sheet 1 Column A Cell 1 the number matches Sheet 3 Column C Cell 2 I want Column L Cell 1 in sheet 1 to Display "NO" .

Thank you.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
It seems to me that you are looking for VLOOKUP