Forum Discussion
EXCEL
HOW TO BULK FINDING FROM 1 SHEET TO ANOTHER SHEET i.e BKID0009547 FROM ONE SHEET TO BKID0009547 FROM OTHER SHEET WE HAVE 2 SHEET HERE AND IT GETS MORE TIME TO FIND ONE BY ONE WITH EACH OTHER PLEAS...
How about using Vlookup:
- Open your Excel workbook with the two sheets you want to compare.
- Select a cell on the second sheet where you want to find the corresponding value from the first sheet.
- Enter the VLOOKUP formula. Assuming you have:
- BKID0009547 (or the value you want to find) in cell A2 on Sheet2
- Column A in Sheet1 contains the value you are searching for
- Column B in Sheet1 contains the value you want to retrieve once a match is found
=VLOOKUP(A2, Sheet1!A:B, 2, FALSE)
This formula looks for the value in cell A2 of Sheet2 in the first column (Column A) of Sheet1 and returns the corresponding value from the second column (Column B) of Sheet1.
- Drag the fill handle down to apply the formula to other cells if needed. This will copy the formula and adjust the cell references accordingly.
- Ensure the data is correctly formatted. Sometimes data might not match due to formatting issues, so make sure the formats are consistent across both sheets.
