Excel Lookup Question
 

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

Excel Lookup Question
 

Something like this:

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

Check out helpfile entry on VLOOKUP for more help if needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Newfie809" wrote:

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

Excel Lookup Question
 

On Sep 1, 3:51*pm, Newfie809 wrote:
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.