How to use Vlookup with web query data (In HTML format)

  • Thread starter Thread starter acxes
  • Start date Start date
A

acxes

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/com...dg=microsoft.public.excel.worksheet.functions
 
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:X1000"),5,FALSE),"")
 
Back
Top