lookup using only the functions
 

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

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

Vaya con Dios,
Chuck, CABGx3



"seven t" wrote:

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"seven t" schrieb im Newsbeitrag
news:fXXtd.65$hp.33@lakeread08...
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

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

"Frank Kabel" wrote in message
...
Hi
try the following typr of array formula
=INDEX(C1:C100,MATCH(1,(A1:A100="county1")*(B1:B10 0="type1"),0))

--
Regards
Frank Kabel
Frankfurt, Germany

"seven t" schrieb im Newsbeitrag
news:fXXtd.65$hp.33@lakeread08...
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