Not sure of your need since you didn't give much info or post a formula(s).
Perhaps INDIRECT will help if your fetch is wiping out the data
=IF(ISNUMBER(D5),VLOOKUP($A5,INDIRECT("Data!B1:X10 00"),5,FALSE),"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"acxes" wrote in message
...
I want to search a name (Primary Key) and want relative data from two
sheets
in another sheet.

I using Vlookup but its giving me #N/A value, is that because of web query
data (In HTML format).

Members Name (To search) are as HTML links in my sheet.




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions