Excel Lookup Question

[Newfie809]

Can anyone help me?

Spreadsheet 1
A B C
Name GL Account Number Description (GL Account)

Harry Potter 021-0132-201-301-100
Mickey Mouse 021-0132-204-301-400
Robin Hood 010-0183-204-001-400
Looking for a formula to
lookup the account code description (B) on Spreadsheet 2 and return to this
empty space in Spreadsheet 1, (C).

Spreadsheet 2
A B
GL Account Number Description (GL Account)

021-0132-201-301-100 Salary Business Department
021-0132-204-301-400 Salary Human Resources
010-0183-204-001-400 Salary

 

[Luke M]

Something like this:

=VLOOKUP(B2,Sheet2!A$2:B$100,2,FALSE)

Check out helpfile entry on VLOOKUP for more help if needed.

 

[jayensmi]

Can anyone help me?

Spreadsheet 1                          
A               B                      C
Name            GL Account Number              Description (GL Account)

Harry Potter    021-0132-201-301-100            
Mickey Mouse    021-0132-204-301-400            
Robin Hood      010-0183-204-001-400            
                                                                               Looking for a formula to
lookup the account code description (B) on Spreadsheet 2 and return to this
empty space in Spreadsheet 1, (C).

Spreadsheet 2                          
A                       B
GL Account Number               Description (GL Account)                

021-0132-201-301-100    Salary Business Department              
021-0132-204-301-400    Salary Human Resources          
010-0183-204-001-400    Salary          

try this site:
http://www.bappit.com/Excel.html. they have a tutorial on vlookup.
they upload tutorials every week.