Use the excel worksheet function Vlookup().



mel;7476197 Wrote:
I don't have access to Access or Visual Basic. All I have to work with
is
excel. I have a list of 55 discount selling schedules each with
different
details. I have a list of numerous customers, to whom each only 1 of
the
discount schedules applies. I have been asked to set up a chart of
this
information.

I would like to enter the 55 discount schedules on one worksheet. I
would
then like to use a second worksheet including the customer information
and
the schedule number, and depending on the schedule number entered, pull
the
information from the discount worksheet so that it appears on the
customer
worksheet. But I think the formula would be too long???

"Gary Keramidas" wrote:

do you just want a formula?

=IF(A2=55,"ABCDEFG",IF(A2=56,"HIJKLMNOP",IF(A2=57, "QRSTUV","")))

--


Gary


"mel" wrote in message
...





--
GaryA