Lookup or an alternative

[CHerzog]

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 #.

 

[Eva]

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)

 

[CHerzog]

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.