Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup options
hi!
lets say i have 2 sheets. 1- calcs, 2- Data i want to lookup a value from the calcs sheet, and have it return a description of some steel that i'll be using. normally thats a lookup(value, Array, Return Array) sort of function. But, here's the twist. the description is actually 2 adjacent cells.. like so Calcs Data a b | a b c 1 item | 1 item Type Size 2 70 "tube 2x4x.125" | ...72 71 tube 2x4x.125 input 70, return the 2 descriptions in one cell. is this possible??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup options
=lookup(value, Array, Return Array colB) & lookup(value, Array, Return Array
ColC) If this post helps click Yes --------------- Jacob Skaria "Derrick" wrote: hi! lets say i have 2 sheets. 1- calcs, 2- Data i want to lookup a value from the calcs sheet, and have it return a description of some steel that i'll be using. normally thats a lookup(value, Array, Return Array) sort of function. But, here's the twist. the description is actually 2 adjacent cells.. like so Calcs Data a b | a b c 1 item | 1 item Type Size 2 70 "tube 2x4x.125" | ...72 71 tube 2x4x.125 input 70, return the 2 descriptions in one cell. is this possible??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup options
thanks!
i changed it slightly - i had forgotten about the '&' symbol. lookup(Value, Array, ReturnArrayColB &" - " &ReturnArrayColC) which also worked. "Jacob Skaria" wrote: =lookup(value, Array, Return Array colB) & lookup(value, Array, Return Array ColC) If this post helps click Yes --------------- Jacob Skaria "Derrick" wrote: hi! lets say i have 2 sheets. 1- calcs, 2- Data i want to lookup a value from the calcs sheet, and have it return a description of some steel that i'll be using. normally thats a lookup(value, Array, Return Array) sort of function. But, here's the twist. the description is actually 2 adjacent cells.. like so Calcs Data a b | a b c 1 item | 1 item Type Size 2 70 "tube 2x4x.125" | ...72 71 tube 2x4x.125 input 70, return the 2 descriptions in one cell. is this possible??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) |