vlookup and if formula help

[srollins13]

Table:B2:E4
Tracking Number Processed Shipped 2nd Scan
991120330008956 X X GOOD
991120330008957 X X GOOD
991120330008958 X X GOOD

Formula Used:
=IF(A3=VLOOKUP($A$2,$A$2:$A$999,1,FALSE),"DUPLICATE",A6)

I'm trying to enter data in column a and return a duplicate result or the cells value as put in. The beginning of the formula is where I am tested. What is wrong with it?

[ratcat]

G'day

The formula and the table you have display don't seem to match

More information is required. Maybe post a dummy example of what your trying to achieve. Before and after results will help.

Cheers

RC

[srollins13]

Okay I attached a workbook i am using to create the format and formulas. I hope this helps.

[ratcat]

G'day

Still unsure of what your trying to achieve but here a shot in the dark.

Copy and paste into B2 and copy drag down

=IF(COUNTIF(A:A,A2)>=2,"DUPLICATE",A2)

Cheers

RC

[mani.ragi]

Good day srollins13,

May be you are trying to find the duplicates.

better sort it and use if(a3=a2, "duplicate","good") in the next coloumn and drag down.

hope it works

[srollins13]

Sorry for being so vague. I am creating a spreadsheet to track shipping labels going out of the processing office, then out of the shipping area. a scanner will be used to input the tracking number on both ends. Column A would be hidden, which is where the original scan will be placed. I need a way to prevent the duplication of tracking numbers, if the data entered matches any number in the above cells in that column I need a result of "Duplicate". If the data matches nothing from above, the result would be the data entered. At the same time I need an X placed in the adjacent corresponding column,ie: "Processed" or "Shipped". Then when the label is scanned the second time, it needs to look up the data in column A. If it matches the display "Good", if not, then display "Not Found".

[ratcat]

Okay we just need to adjust the cell B2 formula then you can copy drag down.

=IF(COUNTIF($A$2:A2,A2)>=2,"DUPLICATE",A2)

.......Then when the label is scanned the second time, it needs to look up the data in column A. If it matches the display "Good", if not, then display "Not Found".

Sorry you lost me again....I guess the 2nd scan is placed in Col F ?

If it matches a cell or is it found in Col A.

Cheers

RC

[srollins13]

Yes, the second scan is placed in Col F. The data entered in Col F needs to be compared to the original data entered in Col A. If there is a match the result would be "good" or "Not Found" in Col E. BTW I really appreciate your help. Thank you.

[ratcat]

G'day

Please see attachment

Cheers

RC

[srollins13]

works great! thanks!