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