Finding data from another sheet- maybe using VLOOKUP?

ankitmishra01

New Member
Joined
Oct 14, 2015
Messages
2
Hello,

I am new to MS Excel and I have small question. On Sheet 1, I have the following data (in column order):

Response NoTable NoSurvey DateConstitueny Names (AC)Mandal NamesVillage Names
(I have data)(I have data)(I have data)Need to findNeed to findNeed to find

<tbody>
</tbody>

On Sheet 2, I have the following data (column order):

Constitueny Names (AC)Mandal NamesVillage NamesTable No.Survey Start DateSurvey End Date
(I have data)(I have data)(I have data)(I have data)(I have data)(I have data)

<tbody>
</tbody>

ISSUE:

I need to use an excel formula to find the missing information in Sheet 1:

Constitueny Names (AC) (Need to find)

Mandal Names (Need to find)

Village Names (Need to find)

The information is in Sheet 2. I have tried to use the VOOKUP formula:=VLOOKUP(B1,Sheet2!A2:F2225,1,FALSE)

This formula is producing an error. Can anyone help with this?

Thank you in advance,
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

WarPigl3t

Well-known Member
Joined
May 25, 2014
Messages
1,609
the range of a vlookup table needs to have the search value on the left most column of the range. To put it simply, select the entire column D(Table No.) of sheet 2 and move the entire column to become column A. Then in sheet 1 cell D1 enter this formula

=vlookup(b2, sheet2!$a$2:$d$999, 2, false)
 

Godspeed64

New Member
Joined
Oct 9, 2014
Messages
20
As per above, if the unique item you are using as the basis to trigger your search is Table No., the items you intend to map into your worksheet should be to the right of the Table No. column.

You might want to lock certain cells when doing your VLOOKUP to ensure the formula doesn't move with the cell (if you do not want that) by pressing F4 over the Cell reference numbers.

Also, if for some reason you are unable to amend the second table (usually I just copy it out, VLOOKUP, paste as value, and don't save the second table; this is to maintain the sanctity of the "raw" data set), then VLOOKUP is insufficient. You would need to use a combination of INDEX and MATCH to achieve what you need.
 

ankitmishra01

New Member
Joined
Oct 14, 2015
Messages
2
Thank you very much for the replies. I appreciate it. Seems to be working:) - let you know if there is a problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,249
Messages
5,576,943
Members
412,753
Latest member
Coach_Olson
Top