Thread: Need help with setting up IF formula in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Bill Manville Bill Manville is offline
external usenet poster
  
Posts: 473
Default Need help with setting up IF formula in Excel
Put your 30 course codes in a column
Put the 30 descriptions in the adjacent column to the right.
Say they occupy A1:B30 on sheet named Table.

In column E of your main sheet, for example in row 2, put formula
=VLOOKUP(D2,Table!$A$1:$B$30,2,FALSE)

Copy to the other cells in column E

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply With QuoteReply With Quote