Comparing to columns

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

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
 
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)),"","Taxable")
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
 
Back
Top