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