lookup using only the functions

[seven t]

hi to all,

a go ahead thanks for those who will reply.

i have these small database with the fields (county, type, cost)

i would like to find the cost for a matching county & type

i would like to do this using the functions instead of a pivot table

how do i do this?

/lrvelasquez

 

[CLR]

You might like the Data > Filter > AutoFilter feature......

Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi
try the following typr of array formula
=INDEX(C1:C100,MATCH(1,(A1:A100="county1")*(B1:B100="type1"),0))

 

[seven t]

Hi Frank,

Thanks the formula works.
I have been reading books on Excel but I could not find this reference.

Can you please help explain that function to me.
I am familiar with the Index and match Combination

However thier function in an array is a bit strange to me.

Thanks
lrvelasquez