Challenge - Please Help!

[couger77]

I need to return a value in J3:J25 on sheet (DATA)

The value being any of the following A through L or BOE(U), BOE(NU)
GE, etc... as represented on sheet (SOURCE)

The variables are highliegted. And it is based on Age, Sex, an
Amount.

Any help is greatly appreciated!!

Jeremy

***Please see attached**

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39329

 

[Bernard Liengme]

I could be wrong but most people want a simple statment of the problem and
have no wish to open files.
What have you tried so far? VLOOKUP/ SUMPRODUCT?
Can you describe the problem in a few words - maybe a subset of the problem
to get started.

 

[couger77]

I don't like having to attach files either, but I figured it would save
time explaining. The problem I have is not knowing how to do I multiple
lookup with the given scenario. Have you opened the file? That will
help you understand better.

Thanks!

Jeremy

 

[Mike]

Jeremy:

I've looked at your attachment. I don't think the lookup
functions will work in this situation. I do believe you
will need a macro to accomplish this.

Mike.

 

[couger77]

Alrighty then, anyone who can help me build a macro, I thank you i
advance.

: )

Jerem

 

[Harlan Grove]

Alrighty then, anyone who can help me build a macro, I thank you in
advance.

Unless Mike wants to keep going with this, you aren't going to get many other
people helping you if you expect them to look at the file attached to your
original posting. Most of us won't open it - PERIOD. Explain the problem in
prose, wait for the few who will open your file to offer suggestions, or learn
by doing without assistance.