Garetjax: If you go to Data/Import External Data/New Database Query you will be able to build an SQL Link into your Access Database.
This is a whole new experience, filled with traps and frustrations, but with bit of research and patience, you will be able to solve your problem.
I am no...
In you third paragraph, you were asking for a way to return the ROW NUMBER to a HLOOKUP formula. I suggest you use MATCH("Data you're lookung for", Range).
Hi, I have just joined the Forum. Greetings from Australia. While I am the "go to guy" for all things Excel where I work, the more I read in sites like this, the more I realise how little I know! This is why I find this site incredibly helpful, and hopefully supportive through this forum.