Mar 29 2023 01:36 PM - edited Mar 29 2023 01:40 PM
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
Mar 30 2023 01:06 AM
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!