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