My worksheet has two tabs. One tab is where data is entered by reviewer.
The other tab has three columns of data. I want to be able to look at the
validate that the information entered in the first tab is on the second tab
and then make a decision based upon that validation.

Tab 1 (Entered by processor)
Requested Drug: Cytoxan (Name must match description of Jcode below)
J-code: J8530 (J-code must be in database)
Diagnosis Code (ICD-9) 140.0 (ICD-9 code must be in database)


Approval Status: If Jcode and Diag code are yes, "Approve" needs to show
here. I'd like to include an add'l column that will show the outcome of the
three fields above.

Tab 2 (Database)
J-code Description
ICD-9
J8530 Cytoxan (cyclophosphamide, oral 25 mg) 140.1
J9080 Cytoxan or Neosar (cyclphosphamide 200 mg) 140.3
J9090 Cytoxan or Neosar (cyclophosphamide, 500 mg) 140.4
J9091 Cytoxan or Neosar (cyclophosphamide, 1.0 gm) 140.5

I'm just starting to work with some of the more advanced functions, so I'm
not sure which function I need to use. I don't know if it makes a difference
or not, but I have named the ranges in the database.

Any help would be appreciated.



--
Lady