vlookup

R

Ronald

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'
 
B

Bob Phillips

=VLOOKUP(0.1,Sheet1!A1:C100,2,False)

then ,2,False)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

Ronald

Hej Bob,

thanks for the answer. I had some problems translating the english terms
into danish. but now it works.

Regards,

Ronald Westerburger
 
B

Bob Phillips

If I had known, I could have done it for you

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top