| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup or an alternative
I have several sheets and I am trying to pull data from the master to the
others, I have been trying to use the Lookup and IF function. But I cant get the right mix any help would be appreciated. EX. Col. 1 Col. 2 Col. 3 Job#'s Item#'s Dates 2556,2554 331 12/09/09 All 332 10/25/09 2554, 333 08/15/09 2558 334 12/09/09 2556,2554 335 10/25/09 Im trying to lookup by job #. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or an alternative
Can you elaborate more about what you need to accomplish?
Based on what you said there I suggest now vlookup(a1,YourSource!A1:C10,2,false) -- Click yes if helped Greatly appreciated Eva "CHerzog" wrote: I have several sheets and I am trying to pull data from the master to the others, I have been trying to use the Lookup and IF function. But I cant get the right mix any help would be appreciated. EX. Col. 1 Col. 2 Col. 3 Job#'s Item#'s Dates 2556,2554 331 12/09/09 All 332 10/25/09 2554, 333 08/15/09 2558 334 12/09/09 2556,2554 335 10/25/09 Im trying to lookup by job #. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup or an alternative
I need to lookup by Job # and show the adjacent cells in the row. But the
information is already in numerical order by Item # and needs to stay that way. "Eva" wrote: Can you elaborate more about what you need to accomplish? Based on what you said there I suggest now vlookup(a1,YourSource!A1:C10,2,false) -- Click yes if helped Greatly appreciated Eva "CHerzog" wrote: I have several sheets and I am trying to pull data from the master to the others, I have been trying to use the Lookup and IF function. But I cant get the right mix any help would be appreciated. EX. Col. 1 Col. 2 Col. 3 Job#'s Item#'s Dates 2556,2554 331 12/09/09 All 332 10/25/09 2554, 333 08/15/09 2558 334 12/09/09 2556,2554 335 10/25/09 Im trying to lookup by job #. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative to using 10 V-lookup formulas | Excel Worksheet Functions | |||
| Returning an alternative value if lookup cannot be found in array | Excel Discussion (Misc queries) | |||
| Alternative to IF | Excel Worksheet Functions | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Case specific LOOKUP alternative | Excel Discussion (Misc queries) | |||
Hybrid Mode
