Vlook up and if statements (I think)
 

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

Vlook up and if statements (I think)
 

Hi,

Please send a small copy of this excel workbook.



"clevejoe" wrote:

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

Vlook up and if statements (I think)
 

Where should I send to?
Sridhar wrote:
Hi,

Please send a small copy of this excel workbook.

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
[quoted text clipped - 16 lines]

Thanks

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

Vlook up and if statements (I think)
 

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


Regards,.
Howard

"clevejoe" <u20511@uwe wrote in message news:5e4deb2d638a9@uwe...
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

Vlook up and if statements (I think)
 

Just wanted to thank L. Howard Kittle for all the help in achieving my goal
on this work sheet.

Thanks a bunch


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


Regards,.
Howard

Im working on a data base with several thousand rows and about 60 columns
on
[quoted text clipped - 26 lines]

Thanks

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