Howdy all

I want a list in a second workbook (to be issued to a contractor) to look up columns on a master list and return positive values without having to use the filtering method. Imagine if you will the master list to be a complete inventory (quite long with many blanks with the various jobs running across the sheet left to right) and the list in the second workbook to be summary of what is required for each particular job.

does anyone know the formulas etc for this or the method for achieving it?

cheers