Finding data from another sheet- maybe using VLOOKUP?

[ankitmishra01]

Hello,

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Response No[/TD]
[TD]Table No[/TD]
[TD]Survey Date[/TD]
[TD]Constitueny Names (AC)[/TD]
[TD]Mandal Names[/TD]
[TD]Village Names[/TD]
[/TR]
[TR]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[TD]Need to find[/TD]
[TD]Need to find[/TD]
[TD]Need to find[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Constitueny Names (AC)[/TD]
[TD]Mandal Names[/TD]
[TD]Village Names[/TD]
[TD]Table No.[/TD]
[TD]Survey Start Date[/TD]
[TD]Survey End Date[/TD]
[/TR]
[TR]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[TD](I have data)[/TD]
[/TR]
</tbody>[/TABLE]

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,

 

[WarPigl3t]

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]

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]

Thank you very much for the replies. I appreciate it. Seems to be working - let you know if there is a problem.