doing a lookupbased on 2 values

[jshaw82]

Hi All,

I have attached a spreadsheet to show the example I am trying to get this to work with.
I have a drop down box with the months in. and I want the cell on sheet2 C3 to display the value that is in the column "Com" related the the name in col A but the data is clustered together by 4 columns per month so a vlookup wont work so maybe an array or match.

Can anyone offer some assistance?

lookup2.xls

Thanks

John

[Pete_UK]

Put this in C3:

=INDEX(Sheet1!$B$3:$I$6,MATCH($A3,Sheet1!$A$3:$A$6,0),MATCH(C$1,Sheet1!$B$1:$I$1,0)+1)

Hope this helps.

Pete