Thread: lookup data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jaci Jaci is offline
external usenet poster
 
Posts: 6
Default lookup data

I have a spreadsheet with a column that must have a specific code inserted.
I have a separate spreadsheet with the code and correlated info. How can I
created a lookup field in that one column that allows me to choose from the
codes in the second spreadsheet as well as see the correlated info for each
code?