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