Help! Withexcel conditional formula

[bernardosilvab]

Hi there, hope someone might help me out with this formula im trying to write.
(Excel_2013)

I have 2 Sheets.
Sheet 1 has 2 colums. Colum#1 are acronyms, Colum#2 is emply
Sheet 2 has 2 colums. Colum#1 are acronyms, Colum#2 are the corresponding acronym's_fullname.

So,

In sheet 1, Colum#2 i need the corresponding acronym_fullname of that shown in colum#1(sheet1), as it show in Sheet 2.

Thanks,
BS.

 

[Bob Phillips]

Try

=VLOOKUP(A2,Sheet2!A:B,2,False)

 

[bernardosilvab]

Try

=VLOOKUP(A2,Sheet2!A:B,2,False)

Hi Bob,

Thanks man, already found this

=INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0))

worked perfect. thanks anyway. gonna try that one too.

BS.

 

[Bob Phillips]

They should both work. VLOOKUP only looks right, whereas the INDEX/MATCH combo can lookup right or left, so it is more versatile, but of course it is 2 function calls as against 1.