What a long question? Have you read Help to see how VLOOKUP works - I think
that answers your question. Happy to give more info if question gets
refined.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dee" wrote in message
...
I have a spreadsheet that I want to track the visits of patients and the
how
much I would owe the site for the visits. I have another spreadsheet that
works out the cost. per visit. For example, the patients would be seen
Screening, Day 1, Day 2, Day 8, Day 15, Day 22, Day 36 and Final Visit.
The
cost for each visit varies. I have a spreadsheet that calculates the cost
of
each visit and also the total cost depending on the number of visits. Say
patient 003 had completed Screening, Day 1 and Day 2, my second
spreadsheet
calculates how much we would owe for the patient for the 3 visits. On my
first spreadsheet I have excel enter the dates of each visit by adding the
days to visit Day 1. At the end of the row I have a count of the number of
visits that have been completed. I would like to have excel enter the cost
of
the number of visits. For example, if at the end of the row the patient
had
completed 4 visits, I want excel to enter the cost of the 4 visits that
has
been calculated on the second spreadsheet. There are 8 visits in all. What
type of formula could I use to achieve this. I want excel to look in say
cell F2, if there is a 4 in F2 how can I have excel enter the right cost
for
4 visits in cell G2. Would I use an If, then function. If F2 is 4 then
enter
$4,567.99 which is calculated on the second spreadsheet and if F2 is 5,
then
enter $8,987.00 etc. I'm not sure how to approach this. Any help would be
greatly appreciated. I am using Excel 2003.

Best regards,

Dee