excel techs,
This is the formula I am using to get data from a database called Montana...
=Montana|last!'X Y' this works, gets data from database
I would like to change it, so that X value is replaced with the data that is in another cell(A1) and the Y value changed to data in a different cell(A2).
Have tried:
=INDIRECT("Montana|last! ' "&A1&" "&A2&" ' ") but this does not work returns #ref!
when I use the evaluate formula it ends
=INDIRECT("Montana|last! 'CellA1 CellA2' ")
It seems that it gets close to the final answer but I need it exactly to end at( =Montana|last! 'A1 A2' )so that the database returns the data.
Any help.... Thanks
Brian
Bookmarks