Comparing to columns
 

I have 2 worksheets. In one I have a column Vendor Codes (these items in
ths column do not change) and the other I have a column Payee codes which
changes as I run the report.
What I want to do is if there are any items in the Payee Code column that
are on the vendor code list , then I want a column beside of the payee code
that says taxable .
Column D (2nd worksheet) This is a stationary list, does not change
Vendor Codes
AD9
OTS
OID1
SLAO
WVI
WCI
no filings yet
TRA
Column A (1st work sheet)
Payee code
KKI
NWI
OCP
OCP
TRA
TRA
TRA
TRA
TRA

Comparing to columns
 

Hi
In the column where you want Taxable to appear, enter the following formula.
I took it that yout Payee list starts in A1, and your vendor list in D1. If
not, simply adjust the row numbers ion the formula to suit

=IF(ISNA(VLOOKUP(A1,Sheet2!$D$1:$D$8,1,0)),"","Tax able")
If there is no reference to a vendor in the payee code, nothing will show,
else the word Taxable will appear.

--
HTH

Kassie

Replace xxx with hotmail


"Donna" wrote:

I have 2 worksheets. In one I have a column Vendor Codes (these items in
ths column do not change) and the other I have a column Payee codes which
changes as I run the report.
What I want to do is if there are any items in the Payee Code column that
are on the vendor code list , then I want a column beside of the payee code
that says taxable .
Column D (2nd worksheet) This is a stationary list, does not change
Vendor Codes
AD9
OTS
OID1
SLAO
WVI
WCI
no filings yet
TRA
Column A (1st work sheet)
Payee code
KKI
NWI
OCP
OCP
TRA
TRA
TRA
TRA
TRA