So what I am trying to do is have a cell match a specific carrier to a cell that has the value of a corresponding city.
The carriers have a list of cities that they correspond to.
So for instance I have cell A1 = City and B1 = Carrier I want B1 to match the value from A1 to a carrier.
I have attached a document so its less clear. Right now I am using the formula =INDEX(A86:C115, (MATCH(A1,A87:C87,0)), MATCH(A1,Vitranlist,0)) which only works for the one value of A1
I attached an example if you could help me figure out the formula on there I should be able to use that and apply it to my document
Bookmarks