match two criteria check if they match another criteria then return result. Query vlookup

I have looked at your example and cannot determine what the answer should be from your explanation. If you were to do this manually, what would the end result be and what is the logic to arrive at that end result. You have not provided sufficient information to arrive at a solution. Using your example explain step by step how you would determine the expected result manually.

Originally Posted by alansidman

I have looked at your example and cannot determine what the answer should be from your explanation. If you were to do this manually, what would the end result be and what is the logic to arrive at that end result. You have not provided sufficient information to arrive at a solution. Using your example explain step by step how you would determine the expected result manually.

Sorry I know it's hard to understand. I'll try to explain it as best I can.

You will enter data into the Hospital 1 and 2 columns.

It then needs to quote the price from one of the 3 tables.

For example - I have entered data in hospital 1 and 2. This data has two hospitals from the contracted table it should give you 2548

If I enter one hospital from the contracted table and one from the non contracted table it should give you 2719

If I enter two hospitals from the non contracted table it should give you 2719

If I enter data that matches the hospitals from both predetermined table columns and it will give you the price. These prices are all different depending on what data you have entered.


I can get it to work if I use a helper column but it will only work with one result anything else I enter will gives me an error like #N/A or #REF or #VALUE depending on what way I type the formula.

I found this post on here "search two columns match then vlookup" Sorry I can't post links yet

I think it's something like this but i don't really understand what it is doing.

I tried this in F5 but it didn't work -

Please Login or Register  to view this content.

I really hope that helps.

Let me know if it still doesn't make sense.

I don't quite get this. Maybe try at F3

Formula:

Please Login or Register  to view this content.

Originally Posted by Bo_Ry

I don't quite get this. Maybe try at F3

Formula:

Please Login or Register  to view this content.

Thanks that seems to do what I need it to do.

You will not get it as it will become part of a bigger spreadsheet for working out pricing. I'm sure there is an easier way to do it but right now this is the best way i can think of doing it.

I've attached the spreadsheet that it will be added to. Might make more sense or most likely will confuse you more. It's a little broken as I've been adding columns and such. Just want to get this part working first then I'll fix the rest. Anyways feel free to have a look and if you know of a better way to do what I need it to do let me know. I'm out of ideas

Basically all I want it to do is when I add my engine hours, which are normally around 1.6 to 2.0, have it add up the final price with the other data that has been entered.

So the formula is Engine Hours x Price + any extras that get tagged on. Things like road transport and then like.