software

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

I'm not sure, but it sounds like =vlookup() or a variation of that should work.You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html (for =vlookup())
and
www.contextures.com/xlFunctions03.html (for =index(match()))

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

--

Dave Peterson

Dave

I have decided to allocate the customer name with a number, then add the
three columns together, then within the target cells a specific formula will
look for that number via a lookup to return the fourth column.

Thank you for your response

quot;Dave Petersonquot; wrote:

gt; I'm not sure, but it sounds like =vlookup() or a variation of that should work.
gt;
gt;
gt; You may want to read Debra Dalgleish's notes:
gt; www.contextures.com/xlFunctions02.html (for =vlookup())
gt; and
gt; www.contextures.com/xlFunctions03.html (for =index(match()))
gt;
gt; SteveH wrote:
gt; gt;
gt; gt; i need to drop data into a spreadsheet, from this data I wish to
gt; gt; automatically extract from this spreasheet and populate into another
gt; gt; spreadsheet values, the data will in succesive columns (clm) have, in the 1st
gt; gt; clm the customer identity, could be numeric say 350, alphanumeric say col001
gt; gt; or just alpha say roy; 2nd clm will have a four digit No., the 3rd clm a six
gt; gt; digit No., being a date. The first column against any customer I.D. can have
gt; gt; a combination of these four digit numbers and dates. I wish then to have in
gt; gt; place in my target cell specific individual formulas that will identify and
gt; gt; require three adjoining cells on the same row to match the criteria in that
gt; gt; cell, i.e. say col001 and say 0291 and say 200512,if these exist then return
gt; gt; the value in the same row from the 4th clm; if not enter zero.Thanks for any
gt; gt; HELP
gt;
gt; --
gt;
gt; Dave Peterson
gt;