m_vishal_c
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 209
- Office Version
- 365
- 2016
- Platform
- Windows
Hi, i have two excel sheet in same workbook.
Sheet1 is having
<colgroup><col><col></colgroup><tbody>
</tbody>
Sheet2 is having
<colgroup><col><col></colgroup><tbody>
</tbody>I am going to apply vlookup on Sheet1 :- B3(abc ltd row) and get value from Sheet2 but it shows "#N/A"
Please advice me how can i get those value?
heaps in advance
Sheet1 is having
<colgroup><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col></colgroup><tbody>
</tbody>
Sheet2 is having
A | B |
Compnay | value |
abc | 1 |
de | 2 |
ghi | 34 |
jkl | 4 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Please advice me how can i get those value?
heaps in advance