Quote Originally Posted by protonLeah View Post
I don't know what your goal is from looking at the workbook. There are no comments and no indicators of desired results.
Well, back to my first post, unless this is too confusing for you..
If origin = a, then matrix lookup zip code within column A of tab 1, and return all rates for specified providers of this tab
elseif origin = b, then matrix lookup zip code within column A of tab 2, and return all rates for specified providers of this tab
elseif origin = c, then matrix lookup zip code within column A of tab 3 and tab 4, and return all rates for specified providers of these tabs
elseif origin = d, then matrix lookup zip code within column A of tab 3 and tab 4, and return all rates for specified providers of these tabs
elseif zip code isn't found within the specified ranges, then rates = "SPOT"
Basically, "Target and Actual table" is the tab that has two values the macro needs to look at. First, is the 'origin' (column A) which should tell the macro which of the other tabs to look at for rates. The second is the 'postal code' (column D), which give the macro the single number to look up on the tab specified by the 'origin.' The postal code being looked up, will be found within postal code ranges on the numbered tabs (5,12,22,22B,30, and 30B) in column A of those tabs.

The objective is to have all the columns on the 'Target and Actual table' with a name/number on them (Column G, I, K, M, O, etc.) to have the rates from that person (or number) from that particular 'origin' filled in. (I say person or number, because they are both unique identifiers to each other, so it just a matter of preference, for my actual project, it would be easier to use the numbers (row 3) as some of the actual names are quite long)

The spreadsheet is to be used as a cost comparison analysis between all 'Names' from each origin, to the zip code being looked up. The reason there are two tabs that have the letter 'B' in them( 22B, and 30B), is because two of the origins have two different sets of 'names' with different postal ranges, so if the 'origin' is '30', then the zip code would need to be looked up on both tab '30', and '30B', however many postal codes will not be found on the "B' tabs (which is fine,) in which case I would want a value of $0.00 returned for rates not found on these tabs.

Hope this helps you understand it a bit more.