Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
Hi all,
I want to modify a spreadsheet so that the user picks 1 variable from 4 different columns and a cell that has the value equivalent to these 4 conditions is automatically highlighted - all the data is within the same spreadsheet For example, if you pick item A (variable 1), order 100 (variable 2 etc.)....then the value of this item is $100 (highlight this cell) Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
.. all the data is within the same spreadsheet
Data Filter Autofilter seems the natural* fit here to achieve what you're after *Also the easiest, as the autofilter dropdowns on the 4 key cols will give your users the unique selections in the dropdowns The ultimate filtered row(s) satisfying all 4 key col selections will be the result line(s). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vince" wrote: Hi all, I want to modify a spreadsheet so that the user picks 1 variable from 4 different columns and a cell that has the value equivalent to these 4 conditions is automatically highlighted - all the data is within the same spreadsheet For example, if you pick item A (variable 1), order 100 (variable 2 etc.)....then the value of this item is $100 (highlight this cell) Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
Max wrote: .. all the data is within the same spreadsheet Data Filter Autofilter seems the natural* fit here to achieve what you're after *Also the easiest, as the autofilter dropdowns on the 4 key cols will give your users the unique selections in the dropdowns The ultimate filtered row(s) satisfying all 4 key col selections will be the result line(s). Sorry Max, that didn't work (was my first choice as well..) The data is in 2 drop down lists -the combination of these 2 cells need to then look up and return or highlight a value in a table. I have tried a IF statement but I am not that advanced I'm afraid... Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
"Vince" wrote:
Sorry Max, that didn't work (was my first choice as well..) The data is in 2 drop down lists -the combination of these 2 cells need to then look up and return or highlight a value in a table. I have tried a IF statement but I am not that advanced I'm afraid... Difficult to visualize what's happening there .. Could you use either of the 2 free filehosts listed below to upload your sample and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
For cjoint.com (it's in French)
Here it is in English: http://translate.google.com/translat...l%3Den%26lr%3D Biff "Max" wrote in message ... "Vince" wrote: Sorry Max, that didn't work (was my first choice as well..) The data is in 2 drop down lists -the combination of these 2 cells need to then look up and return or highlight a value in a table. I have tried a IF statement but I am not that advanced I'm afraid... Difficult to visualize what's happening there .. Could you use either of the 2 free filehosts listed below to upload your sample and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
Vince,
From your orig. post, if the value is to be returned from a certain col range satisfying values for 4 variables (also defined/named ranges), then something like this array-entered (press CTRL+SHIFT+ENTER) should work: =index(ReturnCol,match(1,(Var1=val1)*(Var2=val2)*( Var3=val3)*(Var4=val4),0) whe ReturnCol = Named range for value to be returned Var1 = Named range for variable 1 [Var2,3,4 similar] val1 = The selected value for variable 1 [val2,3,4 similar] - point to the DV cell for the variable ReturnCol and Var1, Var2, Var3, Var4 should all be identically structured and they cannot be entire col references [eg: A:A, X:X, etc] The above construct works for unique matches. It will return only the 1st match in ReturnCol which satisfies all 4 variables (if any). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
"Biff" wrote:
For cjoint.com (it's in French) Here it is in English: .. Thanks for that, Biff. That should help the OP, if he is still interested in pursuing the matter, that is. Unfortunately, I'm not able to access google.com (or any links pointing to google.com) for the better part of a normal day. cheers. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell / lookup
"Biff" wrote:
For cjoint.com (it's in French) Here it is in English: .. Thanks for that, Biff. That should help the OP, if he is still interested in pursuing the matter, that is. Unfortunately, I'm not able to access google.com (or any links pointing to google.com) for the better part of a normal day. cheers. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Biff" wrote in message ... For cjoint.com (it's in French) Here it is in English: http://translate.google.com/translat...l%3Den%26lr%3D Biff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |