combining vlookup function

[handri]

Good day,

I need to combine this function with vlookup. Due to i need to ensure no bar code data are missing if something occur while handling this.

=IF(A10="","",IF(A10='BARCODE REGISTER'!A10,"PASS","NG"))

So if someone scan without follow the sequence number. The bar code will also detect even not follow the sequence number.

thank you

 

[Special-K99]

Depends what you mean by "combine".

Explain in words what you are trying to achieve

 

[handri]

Depends what you mean by "combine".

Explain in words what you are trying to achieve

Meant if i can vlookup or something that can help me to compare between 2 sheet workbook.

Sheet 1. Data entry which lookup into sheet 2.

Sheet 2. Data bank to ensure sheet 1 match with data entry in sheet 1.

[/URL][/IMG]

sorry for my bad English

thank you

 

[Special-K99]

So where would this VLOOKUP fit in with your original formula?

 

[handri]

i dont know. If you have workaround or have any suggestion for formula.

 

[Special-K99]

You need to clearly specify what you're trying to do.
So far you haven't.

You have a formula and you want a VLOOKUP in there.
That's all you've said.
The onus is on you to describe what you want.