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
• 38,020 points
735 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
• 63,720 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, 2023 in Others by narikkadan
• 63,720 points
601 views
0 votes
1 answer
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE

answered Mar 30, 2023 in Others by narikkadan
• 63,720 points
429 views
0 votes
1 answer

Copying a sheet with specific formatting from an excel file to a new output

Using Python and the openpyxl package, you ...READ MORE

answered Mar 31, 2023 in Others by Kithuzzz
• 38,020 points
10,350 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
• 63,720 points
641 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
• 63,720 points
946 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
• 63,720 points
3,408 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
• 63,720 points
990 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
• 63,720 points
1,523 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, 2023 in Others by narikkadan
• 63,720 points
343 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