HALLELUJAH!!! Thanks MyVeryOwnSelf, such a simple solution. I'm not too
familiar with the VLOOKUP formulas, this has been so helpful. And to L.
Howard and Debra, I want to sincerely thank both of you as well, especially
for all 3 of you responding so quickly. I prayed and said, "Lord, please have
someone send me a quick and simple solution today, so I can take a rest from
this!" May He bless you all dearly.

I don't know if any of you are still in the mood to help me out on 2 more
issues with this project, if you are, here goes.

1) When trying to hide the Alert Errors in certain cells (some have
formulas/calculations, totals,etc.), I found in several posts to just go to
Conditional Formatting†’Formula Is | =ISERROR(cell reference)†’Format†’then
choose white or a color matching the cell color for the text. When a cell has
no entry and the Alert Error appears (such as: #DIV/0! or #NAME?), the
Conditional Formatting with the color is not a problem, but when there is a
total or value in that cell, then it can't be seen because of the Conditional
Formatting. Is there a SIMPLE way to just have select cells with the Alert
Error to be blank (while still keeping the cell color if it has one) when
there is an Alert Error, and others I choose to show "$0.00"?

2) Once the above has been accomplished, is there an easy and efficient way
to incorporate these Excel Sheets into a database, while still keeping all
the formatting, calculations, cell colors, column placements, text
blocks/titles, and the actual look of the way it is designed graphically?

I know this is a lot, and for me it is a big task, but I know there must be
a way.
--
In God''s Harmony


"MyVeryOwnSelf" wrote:

Let's say the 1st column needs a drop-down list with 3 Procedures:
Back Adjustment, Massage, Nutrition Book
The 2nd column needs a drop-down list for the Pricing Types: Regular,
Medicare, Cash
The 3rd column will then automatically fill in the correct pricing
according to the "Procedure and Pricing Type"
(This is because the price is different depending on which of the 3 is
chosen: Regular, Medicare, Cash).

For example purposes, let's say these are the prices:
Regular Medicare Cash
Back Adjustment $80 $40 $60
Massage $60 $20 $40
Nutrition Book $30 $15 $20

The 4th column will be Quantity, and the 5th Total Price (These are
just basic calculations: Price x QTY=TOTAL) This ofcourse is not the
hard part for me, LOL.

One way is to start by putting the above price table in Sheet2!A:D.

To fill in the third column of Sheet1, put this in Sheet1!C2 and copy down:
=VLOOKUP(A2,Sheet2!A:D,
IF(B2="Regular",2,IF(B2="Medicare",3,IF(B2="Cash", 4,5))),
FALSE)
The idea of the IF() is to select a column of Sheet2 to use based on what's
in Sheet1!B2.