View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Newfie809 Newfie809 is offline
external usenet poster
 
Posts: 61
Default 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