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):
<tbody>
</tbody>
On Sheet 2, I have the following data (column order):
<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,
I am new to MS Excel and I have small question. On Sheet 1, I have the following data (in column order):
Response No | Table No | Survey Date | Constitueny Names (AC) | Mandal Names | Village Names |
(I have data) | (I have data) | (I have data) | Need to find | Need to find | Need to find |
<tbody>
</tbody>
On Sheet 2, I have the following data (column order):
Constitueny Names (AC) | Mandal Names | Village Names | Table No. | Survey Start Date | Survey 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,