View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Patton Tim Patton is offline
external usenet poster
 
Posts: 4
Default Looking up values in another file

File 1 ( The lookup file ) has three columns:

Column A: "Profile Number" with entries 1 to 1500
Column B: "Passes" with values 1 or 2
Column C: "Speed" with values 55, 60 or 40

So in File 2 ( the entry file ) A "profile number" is entered in column
A, I then want the prog to open File 1, match the profile numbers and
then copy the corresponding values in columns B and C to Columns E and F
in File 2.

Thanks for helping me out Bob...

Hope this provides a bit more detail.

Cheers mate

Tim



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!