| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Values
Hello
I'm trying to lookup and return a value but based on two conditions being satisfied. I key a code into A21 and a Length into F21 and return a value from the lookup table. So: If A21 and F21 are found in the lookup table then return the value in R4:R158 Similarly, if A21 and H21 are found return the value. I've attached a piece of the spreadsheet that I hope will help explain Many thanks for taking the time Rob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Values
I've attached a piece of the spreadsheet
that I hope will help explain I don't see any sample data and without it I don't think your explantion will be enough to try to figure out what you want to do. -- Biff Microsoft Excel MVP "Rob" wrote in message ... Hello I'm trying to lookup and return a value but based on two conditions being satisfied. I key a code into A21 and a Length into F21 and return a value from the lookup table. So: If A21 and F21 are found in the lookup table then return the value in R4:R158 Similarly, if A21 and H21 are found return the value. I've attached a piece of the spreadsheet that I hope will help explain Many thanks for taking the time Rob |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Values
It would be best to send you the attachment but that doesnt appear possible.
thanks anyway Biff "T. Valko" wrote: I've attached a piece of the spreadsheet that I hope will help explain I don't see any sample data and without it I don't think your explantion will be enough to try to figure out what you want to do. -- Biff Microsoft Excel MVP "Rob" wrote in message ... Hello I'm trying to lookup and return a value but based on two conditions being satisfied. I key a code into A21 and a Length into F21 and return a value from the lookup table. So: If A21 and F21 are found in the lookup table then return the value in R4:R158 Similarly, if A21 and H21 are found return the value. I've attached a piece of the spreadsheet that I hope will help explain Many thanks for taking the time Rob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Values
You can upload a small sample file to a free file host and then post the
link to the file. I use this free file host often: CJoint http://tinyurl.com/24xfnt It's a French site that's translated into English. -- Biff Microsoft Excel MVP "Rob" wrote in message ... It would be best to send you the attachment but that doesnt appear possible. thanks anyway Biff "T. Valko" wrote: I've attached a piece of the spreadsheet that I hope will help explain I don't see any sample data and without it I don't think your explantion will be enough to try to figure out what you want to do. -- Biff Microsoft Excel MVP "Rob" wrote in message ... Hello I'm trying to lookup and return a value but based on two conditions being satisfied. I key a code into A21 and a Length into F21 and return a value from the lookup table. So: If A21 and F21 are found in the lookup table then return the value in R4:R158 Similarly, if A21 and H21 are found return the value. I've attached a piece of the spreadsheet that I hope will help explain Many thanks for taking the time Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| multiple series of values graphed with indep. x values -possible? | Charts and Charting in Excel | |||
Linear Mode
