This is no good OOTB solution to address the need for a cross-site lookup, you would need a custom solution to do this. The Quest Web Parts approach to this problem is to have a simple single-line-of-text field to store the cross-site lookup values which uses the format http://domain/site;#ListName;#ID, which can be interpreted by QWP, but this format is not supported by anything outside of QWP. So unfortunately there isn't a way to support it using OOB SharePoint view yet.
Yuan