i need to drop data into a spreadsheet, from this data I wish to
automatically extract from this spreasheet and populate into another
spreadsheet values, the data will in succesive columns (clm) have, in the 1st
clm the customer identity, could be numeric say 350, alphanumeric say col001
or just alpha say roy; 2nd clm will have a four digit No., the 3rd clm a six
digit No., being a date. The first column against any customer I.D. can have
a combination of these four digit numbers and dates. I wish then to have in
place in my target cell specific individual formulas that will identify and
require three adjoining cells on the same row to match the criteria in that
cell, i.e. say col001 and say 0291 and say 200512,if these exist then return
the value in the same row from the 4th clm; if not enter zero.Thanks for any
HELP
Bookmarks