=VLOOKUP(K1, Sheet2!A:B, 2, FALSE)

This formula assumes that you want to search for the value in cell K1 of sheet1 and retrieve the corresponding value from column B of sheet2.

Here’s a breakdown of the formula:

  • K1 is the value you want to search for in sheet2.
  • Sheet2!A:B specifies the range in sheet2 to search for the value. It includes columns A to B.
  • 2 indicates that you want to retrieve the value from the second column (column B) of the range.
  • FALSE indicates an exact match is required.

You can drag this formula down to apply it to other cells in column K of sheet1. It will automatically adjust the row references accordingly.

Remember to adjust the sheet and column references in the formula based on your actual sheet names and data range.

Note: If you’re using a localized version of Excel, the formula syntax may be slightly different.