ganito gusto kong mangyari under column A kunyari word is apple then column B is orange gusto ko na when I enter the data on column A automaticallu lalabas si orange sa column B and so on and so forth please help i need a formula po huhu help masters please help
vlookup formula po.
Sheet1 yung main, Sheet 2 for data:
Sheet1 lagyan mo sa column A row 1ng Apple
Sheet2 gawa ka table for data mo sa Sheet1, column A row 1 Apple katapat nun column B row 1 Orange
ito formula sa sheet 1 mo to ilalagay Column B row 1.
=vlookup(A1,sheet2!A1:B1,2,0)