Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ronald Ronald is offline
external usenet poster
 
Posts: 16
Default vlookup

I have one sheet with data looking like:

package no. name costs
0.1 A 50
0.2 B 100
1.1 C 75

I want to use another sheet where i only have to put in the package no. and
all the data from the row will folow. I know that VLookup is a help but
cannot find out how to put in the criteria 'if 0.1 then lookup and return
data'