Forum Discussion

PAWAN147's avatar
PAWAN147
Copper Contributor
Feb 21, 2025

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 PLEASE SUGGEST AND BEST POSSIBLE SOLUTION

 

 

 

 

 

admin
excel
  • Vinod_Sir's avatar
    Vinod_Sir
    Copper Contributor
    Feb 23, 2025

    To highlight matching values: ( Conditional Formatting in Excel will help )

    Let's Follow Along 

    Step1 - Select the column in Sheet1.

    Step2 - Go to Conditional Formatting > New Rule.

    Step3 - Choose Use a Formula and enter:

    =COUNTIF(Sheet2!A:A, A1)>0

    Step4 - select any formatting in this case pick color code 

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Feb 23, 2025

    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
      Sample code:
    =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.

Resources