Hi,
Looking for the function formula to do:


User enters X
User enters Y

Excel looks up the first row for X
then looks down the first column for Y

Then returns the value where they intersect

I tried VLOOKUP and DGET ,

=HLOOKUP(J17,Database!1:1048576,MATCH('Raw Data'!J18,Database!A:A,0),TRUE)

MATCH is retunign the row #- not sure that is correct

J17=X
J18=Y

Many thanks