Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Lookup or an alternative
0 views
Skip to first unread message
CHerzog
Jan 7, 2010, 5:58:01 PM1/7/10
to
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.
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 #.
Eva
Jan 7, 2010, 6:16:01 PM1/7/10
to
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
Based on what you said there I suggest now
vlookup(a1,YourSource!A1:C10,2,false)
--
Click yes if helped
Greatly appreciated
Eva
CHerzog
Jan 8, 2010, 1:34:01 PM1/8/10
to
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.
information is already in numerical order by Item # and needs to stay that
way.
0 new messages