Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 criteria must exist in adjoining cells then rtn val from 4th
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 criteria must exist in adjoining cells then rtn val from 4th
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: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) SteveH wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 criteria must exist in adjoining cells then rtn val from 4th
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 "Dave Peterson" wrote: 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: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) SteveH wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif function does not add up cells, even when criteria is blank | Excel Worksheet Functions | |||
add a column only if 5 other cells on the row satisfy criteria | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
sum cells with criteria | Excel Worksheet Functions |