Try
=VLOOKUP(A2,Sheet2!A:B,2,False)
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.
Try
=VLOOKUP(A2,Sheet2!A:B,2,False)
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.
Bookmarks