View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Importing, but only certain information

Well, the "Vlookup" page in help would be the best one, that's why
Ashish suggested it.

On the blank sheet, type an ID number into A2. Then in B2 you would
put:
=VLOOKUP(A2,data_range,column_number,FALSE)

I would write down a better formula for you, but you need to give more
details, like what your data looks like. You need to know what your
"data_range" and "column_number" are.