software

Im working on a data base with several thousand rows and about 60 columns on
the second worksheet named 2006. The first worksheet contains fomuals based
of the number on the second sheet.
The first column of the second sheet contains mutliple codes. Some of the
codes are duplicated. The second column has what is called a modifier and
the third column has a secondary modifier. the rest of the 60 or sow colummn
are dollar amounts. What I need to do is enter a code on a specific section
of the first work sheet and have it return one of 1 value based on the look
up of of the code on the first sheet to the dollar amount on the second sheet.
I understand the usuage of the VLOOKUP but don't understand how to have it
tell me the value of the the code with the modifiers in the third and fourth
columns (modifiers)
example of worksheets:
If I enter a code of e2320 I need the dollar value of the code returned in 2
ways, one with a modifier of NU and and no second modifer present one with 2
modifiers of NU and KC each in spererate rows.

If needed I can send a small copy of this excel workbook for possible review.

Thanks

Hi,

Please send a small copy of this excel workbook.
quot;clevejoequot; wrote:

gt; Im working on a data base with several thousand rows and about 60 columns on
gt; the second worksheet named 2006. The first worksheet contains fomuals based
gt; of the number on the second sheet.
gt; The first column of the second sheet contains mutliple codes. Some of the
gt; codes are duplicated. The second column has what is called a modifier and
gt; the third column has a secondary modifier. the rest of the 60 or sow colummn
gt; are dollar amounts. What I need to do is enter a code on a specific section
gt; of the first work sheet and have it return one of 1 value based on the look
gt; up of of the code on the first sheet to the dollar amount on the second sheet.
gt; I understand the usuage of the VLOOKUP but don't understand how to have it
gt; tell me the value of the the code with the modifiers in the third and fourth
gt; columns (modifiers)
gt; example of worksheets:
gt; If I enter a code of e2320 I need the dollar value of the code returned in 2
gt; ways, one with a modifier of NU and and no second modifer present one with 2
gt; modifiers of NU and KC each in spererate rows.
gt;
gt; If needed I can send a small copy of this excel workbook for possible review.
gt;
gt; Thanks
gt;

Where should I send to?
Sridhar wrote:
gt;Hi,
gt;
gt;Please send a small copy of this excel workbook.
gt;
gt;gt; Im working on a data base with several thousand rows and about 60 columns on
gt;gt; the second worksheet named 2006. The first worksheet contains fomuals based
gt;[quoted text clipped - 16 lines]
gt;gt;
gt;gt; Thanks

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...tions/200604/1

I will take a look at your example workbook.
Include the details of what you want to happen.Regards,.
Howard

quot;clevejoequot; lt;u20511@uwegt; wrote in message news:5e4deb2d638a9@uwe...
gt; Im working on a data base with several thousand rows and about 60 columns
gt; on
gt; the second worksheet named 2006. The first worksheet contains fomuals
gt; based
gt; of the number on the second sheet.
gt; The first column of the second sheet contains mutliple codes. Some of the
gt; codes are duplicated. The second column has what is called a modifier and
gt; the third column has a secondary modifier. the rest of the 60 or sow
gt; colummn
gt; are dollar amounts. What I need to do is enter a code on a specific
gt; section
gt; of the first work sheet and have it return one of 1 value based on the
gt; look
gt; up of of the code on the first sheet to the dollar amount on the second
gt; sheet.
gt; I understand the usuage of the VLOOKUP but don't understand how to have it
gt; tell me the value of the the code with the modifiers in the third and
gt; fourth
gt; columns (modifiers)
gt; example of worksheets:
gt; If I enter a code of e2320 I need the dollar value of the code returned in
gt; 2
gt; ways, one with a modifier of NU and and no second modifer present one
gt; with 2
gt; modifiers of NU and KC each in spererate rows.
gt;
gt; If needed I can send a small copy of this excel workbook for possible
gt; review.
gt;
gt; Thanks
Just wanted to thank L. Howard Kittle for all the help in achieving my goal
on this work sheet.

Thanks a bunchL. Howard Kittle wrote:
gt;I will take a look at your example workbook.
gt;Include the details of what you want to happen.
gt;

gt;Regards,.
gt;Howard
gt;
gt;gt; Im working on a data base with several thousand rows and about 60 columns
gt;gt; on
gt;[quoted text clipped - 26 lines]
gt;gt;
gt;gt; Thanks

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...tions/200604/1