Yes, it is definitely possible to use VLOOKUP to search for data in one worksheet and return corresponding data from another worksheet. Here are the steps to do so:

1. Open both worksheets 'A' and 'B' in the same Excel workbook.
2. In worksheet 'B', select the cell where you want to enter the corresponding data from worksheet 'A'.
3. Type the
   Code:

   =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

   formula in the selected cell. The syntax of the formula is as follows:
   
   - lookup_value: the value you want to search for in worksheet 'A'
   - table_array: the range of cells in worksheet 'A' that contains the data you want to search through. This range should include both columns of data.
   - col_index_num: the column number in the table_array that contains the data you want to return. In this case, it would be 2 since you want to return the data from the second column in worksheet 'A'.
   - range_lookup: this is an optional argument that specifies whether you want an exact match or an approximate match. In most cases, you'll want to use FALSE to get an exact match.
   
4. Press Enter to complete the formula. The corresponding data from worksheet 'A' should now appear in the selected cell in worksheet 'B'.

Note: Make sure that the lookup_value in worksheet 'B' matches the data in the first column of worksheet 'A'. If there are any discrepancies, the VLOOKUP formula will not work correctly.