Iriemon wrote:
I found this formlua using the search function but cannot understand what it
is saying.

=INDEX(C1:C100, MATCH(D1&D2,'Sheet2'!A1:A100&B1:B100,0))


I'm assuming the D1&D2 references the 2 cells I want to match and the
'Sheet2'!A1:A100&B1:B100 are the cells containing my values to match but
I'm not clear what the C1:C100 and the ",0" are referring to.

How does my table need to be set up? I have the 'Sheet2'!A1:A100&B1:B100
cells filled with my data and 'Sheet2'!F1:F100 containing the value I want it
to return. Do I need to set up my table differently?


Any help would be greatly appreciated!

Thanks

Jim




An explanation of the INDEX and MATCH function can be found he

http://www.contextures.com/xlFunctions03.html