Give results if a value in a column matches

Closed
Jman - Nov 27, 2011 at 11:46 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 30, 2011 at 04:56 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Nov 30, 2011 at 04:56 PM
It seems to me that you are looking for VLOOKUP
0