Match formulae needed

[Natalia132]

Hi there!

I need a formulae help.
I have to compare to sheets of data.
There's column C on sheet 1 with Purchase order numbers.
I would like to have a formulae that would search in Col. A, Sheet 2 and if it matches, than 1 or Y appear.

How is it possible to do?

Thanks in advance

 

[christikae]

Do both sheets of data have the PO Number? If so use vlookup

 

[Natalia132]

Yes, both sheets do include PO numbers, just need to compare them... and see if they match

=VLOOKUP(C2, Sheet3!A1:A379,1)

doesn't work..

 

[Natalia132]

it should be INDEX?

 

[christikae]

I guess I don't exactly understand what you are trying to do.

 

[erik.van.geit]

Hi,

Try MATCH

  A      B  C      
1 LIST 1    LIST 2 
2 AAA    Y  AAA    
3 BBB    N  EEE    
4 DDD    N  III    
5 GGG    Y  GGG    
6 EEE    Y  OOO    
7 FFF    N         
8 CCC    N         
Sheet1
[Table-It] version 09 by Erik Van Geit

RANGE FORMULA (1st cell)
B2:B8 =IF(ISNUMBER(MATCH(A2,$C$2:$C$6,0)),"Y","N")
[Table-It] version 09 by Erik Van Geit

kind regards,
Erik

 

[Natalia132]

IT WORKS!!!

Thanks a lot, Erik!
Have a nice weekend!

 

[erik.van.geit]

You're WELCOME!!
Nice weekend for you too!