Contact US

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.

Students Click Here

Multiple Data Search

Multiple Data Search

Multiple Data Search

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

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

RE: Multiple Data Search

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:

Similarly in cell E13 I have combined the Courier, Service and Type entries:

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

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! Already a Member? Login


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