If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 #. |
Thread Tools | |
Display Modes | |
|
|