Excel VLOOKUP from a different Sheet

0 votes

Although there have been numerous discussions about this both here and elsewhere, I tend to encounter problems with every approach I take.

With the help of the corresponding value from a list of values, I'm attempting to fill up a cell next to it with a value. A list of Test -> Action pairings, for instance, is organized into two columns. I want to enter a value in one cell that already appears in column B, and then I want to enter the corresponding value in column A in the cell that appears next to it. 

Here's my Sheet.

enter image description here

The columns "Actions" and "Tests (test groups)" define the corresponding values.

When I enter a value in the "Action" value, I populate the cells in the "Test (test group)" column (behind the first two columns, from row 10 and down) using VLOOKUP. Easy enough.

But now I require this precise feature on a different sheet. Rows 10 and down of the "Action" and "Test (test group)" columns need to be moved to another sheet while the data in this sheet must still be referenced (rows 2 - 6).

In the cell where I use VLOOKUP, all of the other options I've tested, including INDIRECT, give me either "#REF" or "#VALUE."

Is anyone able to explain how to do this, related to this example?

Dec 9, 2022 in Others by Kithuzzz
• 28,900 points
48 views

1 answer to this question.

0 votes

The worksheet name must be included in your formula. If the name contains spaces or other special characters, only use single quotations. akin to this

=VLOOKUP(A1,'sheet-name-with-dash'!$A$1:$B$9,2,FALSE)

I hope this helps you.

answered Dec 10, 2022 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

answered Jan 13 in Others by narikkadan
• 53,520 points
45 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 22,960 points
536 views
0 votes
0 answers

Download Excel sheet from .NET Core 3.1 Web API with jQuery Ajax client

I am trying to download an Excel ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,630 points
482 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 53,520 points
166 views
0 votes
1 answer

Excel stock and sales data management

you must attach the event handler each ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 53,520 points
88 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 53,520 points
167 views
0 votes
1 answer

Way to overcome Excel Vlookup function limit of 256 characters

If you are using VLOOKUP like this: =VLOOKUP(A2,D2:Z10,3,FALSE) i.e. ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 53,520 points
444 views
0 votes
1 answer

Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

answered Oct 16, 2022 in Others by narikkadan
• 53,520 points
83 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 53,520 points
110 views
0 votes
1 answer

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

answered Jan 9 in Others by narikkadan
• 53,520 points
31 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP