Closed excel help please!!!!

[uNNNERWEARR2323]

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

 

[uNNNERWEARR2323]

hanep

 

[SpectaculairE]

hanep

nagawa mo na? hehehe

 

[uNNNERWEARR2323]

nagawa mo na? hehehe

manual.

 

[SpectaculairE]

manual.

aww dami niyan

 

[uNNNERWEARR2323]

aww dami niyan

so sad

 

[popepong21]

mainam at nakatulong

sir hnd naba pwede mag unhide pag nafilter na?

 

[supernoy]

sir hnd naba pwede mag unhide pag nafilter na?

para ma unhide, kailangan mo muna tanggalin sa filter...

 

[popepong21]

para ma unhide, kailangan mo muna tanggalin sa filter...

wala nabang ibang way sir?

 

[xSAKTOW]

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)

sana makatulong.