Using Excel VLOOKUP function across two sheets

0 votes

I have two sheets in an Excel workbook and want to use the VLOOKUP() function to search a table in Sheet2 and return the result to Sheet1. How might I do this?

The data looks like this:

Sheet1

   A     B     
1  id   name   
2  111  Jacob
3  102  david
4  110  John

Sheet2

   A     B
1  id   Cell   
2  111  03563334879
3  102  03563331234
4  110  03563334222
Sep 29, 2022 in Others by Kithuzzz
• 38,000 points
1,000 views

1 answer to this question.

0 votes

The syntax for VLOOKUP is

VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup)

OR, to start in a cell C2 type:

  • =VLOOKUP(
  • Then click cell A2 (The value to lookup for this row)
  • Then type a comma
  • Then excel allows you to click on another sheet to select the table from sheet2, so this would be range Sheet2!A2:B4
  • comma
  • You want to return the second row from your lookup array so type 2
  • comma
  • You want an exact match so type FALSE
  • close brackets and hit enter
This succeeds for cell C2, but if you drag it down using the cell's lower-right corner, it will fail in consecutive rows since the table array references are relative and will be moved one down for each cell you move. Click on each of them (A2 and B4) and press F4 to make the lookup table array fixed (that's not the right word), or just add the "$" as seen below. This corrects the row and column references so that they won't be altered by copying down.
answered Sep 30, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
0 answers

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

Jul 18, 2021 in Others by Sri
• 3,190 points
817 views
0 votes
1 answer
0 votes
1 answer

Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
878 views
0 votes
1 answer

Using Excel Proper Function with exception | Excel

To accomplish this, you might need to ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 63,600 points
521 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,600 points
1,086 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,600 points
3,551 views
0 votes
1 answer

Using VLOOKUP()

Vlookup takes the lookup value first, so ...READ MORE

answered Nov 5, 2022 in Others by narikkadan
• 63,600 points
526 views
0 votes
1 answer
0 votes
1 answer

Excel VLOOKUP between two sheets failing

Try this: =VLOOKUP(A2,'1'!$A$2:$E$811,5,0) I altered "1"! $A$2:$A$811 to '1'! ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,600 points
684 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,600 points
3,537 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