Lookup question

[Blackie50]

Hi,

Not a great user of lookup tables and was wondering if the following is possible (or by other means?).

Based on the value of Cell1 & Cell2 the value of Cell3 is the lookup value. Cell1 & 2 would be dropdown lists.

example Fund 1 (cell1) Date (cell2) that days price (cell3)

thanks
Jon

[mbarron]

Something like the attached maybe? It uses dynamic ranges for the dates and stocks drop downs and then the Index and Match functions to acquire the Price.

[Bob Phillips]

This array formula demonstrates a technique


=INDEX(K2:K200,MATCH(1,(I2:I200=A20)*(J2:J200=B20),0))

[Blackie50]

Very Good guys - just the ticket

thanks