Comparing rates

[Scubabermuda]

Good Morning,

Need some assistance hope someone here can help me. I am trying to use Excel to compare the values and generate the least cost for a phone number.

The values in column A may not necessarily match column E or be in order for that matter. They are rates from 2 different vendors. Essentially they are the first 6 digits of a phone number and columns B and F are the rates associated with those codes.

So what I am trying to do here is have excel look at the code in A and its associated price in B - compare it to E and F and give me the the code in H and the best rate for that code in I. Have I totally confused you guys here?

This was worth a shot asking all you gurus here. If you can help me I would really appreciate it.

 

[Scubabermuda]

Fantastic cheers

 

[Scubabermuda]

Have a new question, "A" has corresponding rates in "B". I want "C" to populate non duplicated values from A with the higher value from "B".

Any takers?