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'

vlookup
 

=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)

"Ronald" wrote in message
...
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'

vlookup
 

Hej Bob,

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

Regards,

Ronald Westerburger

"Bob Phillips" wrote:

=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)

"Ronald" wrote in message
...
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'

vlookup
 

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

--
HTH

Bob Phillips

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

"Ronald" wrote in message
...
Hej Bob,

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

Regards,

Ronald Westerburger

"Bob Phillips" wrote:

=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)

"Ronald" wrote in message
...
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'