INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Multiple Data Search

Multiple Data Search

(OP)
I have 5 (Five) data inputs... one is variable and is dependant on the input value (so looking for a range) three are columns and one is a row... complicated I know.

I have looked at using Lookup, Index and Match.

Any suggestions or examples?

RE: Multiple Data Search

please explain a little more what you've got and what you're trying to do.

=====================================
(2B)+(2B)' ?

RE: Multiple Data Search

A spreadsheet showing what you have got so far would be helpful.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Multiple Data Search

Unless I'm missing an easy way (which is possible), I don't think that's going to be easy in a spreadsheet, but it should be straightforward in a database.

If this is something you are going to use long-term, with additions and changes to the table of rates, then I'd suggest doing it in a database application.

If you want to do it in a spreadsheet anyway, let us know.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Multiple Data Search

(OP)
if it is possible, I'd like to see if it can be done using a spreadsheet.

RE: Multiple Data Search

Based upon your current table, you don't have all of the data for the choices (e.g., you currently don't have any results if its myHermes & Courier_Collection). Additionally, there's a column of data (Col M) in your spreadsheet that isn't factored in your data from Col A - E. Is this related to insurance of the item/ it's costs (e.g., for MyHermes, Pacel_Drop_Off, Parcel in col M you have values from 0 to 250.1)

RE: Multiple Data Search

See the attached file for some ideas:

In Column I have combined columns J,K and L:
=J3&K3&L3

Similarly in cell E13 I have combined the Courier, Service and Type entries:
=B13&C13&D13

So in F13 a Match function will return the right section of the table.

I have also added a horizontal match on the weight, and a separate match on the value, depending on the return from the main match function.

These are combined in an Index function to return the postage price.

It will take a fair bit of work to make it reliable and robust if you want to add new categories and services, etc though.

Also note you had a typo in postage in the main table, which was stopping Match functions from working.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close