Help! Withexcel conditional formula

bernardosilvab

New member
Joined
Apr 8, 2014
Messages
2
Reaction score
0
Points
0
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

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try

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

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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.
 
Top