# Match formulae needed

#### Natalia132

##### Board Regular
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?

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### christikae

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

#### Natalia132

##### Board Regular
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..

Last edited:

#### Natalia132

##### Board Regular
it should be INDEX?

#### christikae

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

#### erik.van.geit

##### MrExcel MVP
Hi,

Try MATCH
Code:
``````  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``````
Code:
``````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

##### Board Regular
IT WORKS!!!

Thanks a lot, Erik!
Have a nice weekend!

#### erik.van.geit

##### MrExcel MVP
You're WELCOME!!
Nice weekend for you too!

Replies
7
Views
163
Replies
7
Views
198
Replies
4
Views
90
Replies
2
Views
119
Replies
0
Views
42

1,191,581
Messages
5,987,465
Members
440,097
Latest member
Wint

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back