Return value, INDEX MATCH

nesheim

New member
Joined
Sep 21, 2015
Messages
6
Reaction score
0
Points
0
I need to return a value to a cell using a formula, as linking a cell with (example) '=B10'. But I need a formula to give me this number, as linking one at the time manually would take ages in some documents.

I am not very good with INDEX + MATCH, and was hoping someone could help me.

I've attached an excel sheet.

In column C, row 16, all the way down to C46 I need to return what a company bids (in the blue area).
This exact sheet is small, but sometimes they can be very large, my problem is the same.

I'd like excel to return the value company X on route Y bids to the cost (C16:C46). In C16 the value 8200 should show. C17 should show 7800.

I did try =INDEX(A4:I10;MATCH(1;5:5;0);2:9) in C16, but I am not good with INDEX MATCH, and clearly did not get what I wanted.

-How do I get excel to return values from the blue area to C16:C46 based on what each company bids for each route?

Thanks
 

Attachments

  • OEx5.3.xlsx
    13.8 KB · Views: 18
Try:

=INDEX($B$5:$I$10,MATCH(A16,$A$5:$A$10,0),MATCH($B$15&" "&B16,$B$4:$I$4,0))

copied down
 
Back
Top