Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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' |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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' |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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' |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |