Forum Discussion
How to use cell value from imported Webpage in tab A then to another tab (just cell value) to use.
Hello everyone,
I'm new here and need some help to reach my goal so I hope someone can help me out.
I have an Excel with 2 tabs, in one I import part of a page from the web that contains a certain value, I use = to get that value to the second tab where that value has to look in 2 columns to see the match in the "border tab" and then place the value from the adjacent "Up tab" in the adjacent cell.
Thanks, Gerard
If you use Power Query to import data from a web page into Excel.
Once you have imported the data, you can use VLOOKUP or INDEX/MATCH functions to look up values in other tabs based on the imported data.
Here’s an example formula that you can use to look up values in another tab based on a value in your imported data:
=INDEX('Tab Name'!$B$2:$B$10,MATCH(A2,'Tab Name'!$A$2:$A$10,0))
This formula looks up the value in cell A2 of your current tab in column A of ‘Tab Name’, and returns the corresponding value from column B of ‘Tab Name’.
I hope this helps!
- NikolinoDE, thanks very much, I'm gonna try to use this formula.
