Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i setup IF name = this then address = that
hello, i would like to set up something like this: if name = a then address =
x, if name = b then address = y,.... i work with 2 sheets, 1 for invoices 1 for contents or datas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i setup IF name = this then address = that
Hi Frederick ... What are you trying to do here? Are you trying to give an individual cell an instruction to do something according to what the value of another cell is? For example, are you trying to automatically fill cell A2 with the address of the person who's name appears in A1? G'fer -- G-fer ------------------------------------------------------------------------ G-fer's Profile: http://www.excelforum.com/member.php...o&userid=37756 View this thread: http://www.excelforum.com/showthread...hreadid=573381 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i setup IF name = this then address = that
If you have lots of names, it may be better to create a 2 column table on
another sheet (and hide that sheet???). Then you could use this kind of formula: =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) And to avoid looking at errors when there isn't a match: =if(a1="","",if(iserror(vlookup(a1,sheet2!a:b,2,fa lse)),"Missing Name", vlookup(a1,sheet2!a:b,2,false))) Debra Dalgleish has lots of notes on =vlookup(): http://www.contextures.com/xlFunctions02.html frederick wrote: hello, i would like to set up something like this: if name = a then address = x, if name = b then address = y,.... i work with 2 sheets, 1 for invoices 1 for contents or datas -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i setup IF name = this then address = that
On Sat, 19 Aug 2006 04:58:01 -0700, frederick
wrote: hello, i would like to set up something like this: if name = a then address = x, if name = b then address = y,.... i work with 2 sheets, 1 for invoices 1 for contents or datas Set up a table and use VLOOKUP --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i setup IF name = this then address = that
exactly, pb i am real novice in excel, so f.e when i try with 1value it works
well but as long as i try to put more values it just wont work =IF(I5="Frederick";Products!I3;Products!I6) works =IF(I5="Frederick","Karim";Products!I3;Products!I6 ) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i setup IF name = this then address = that
If you only have a few exampls where you want to look this up you could use the OR command. In your example here it would be =IF(or(I5="Frederick",I5="Karim"),Products!I3,Prod ucts!I6) With this is I5 = Frederick or I5 = Karim then it will show the value for Products!I3, if it does not equal either if these values then it will display the value in Products!I6 You can also nest many OR commands within these brackets. If what you are looking for is to be able to display different results depending on the input in I5 then you would probably need to se a VLOOKUP command which woul be along the lines of =vlookup(I5,"Range","Column",FALSE) If this is what you need then post again with a little bit more info about the data you have and what you are trying to find. Hope this helps Regards Carl frederick Wrote: exactly, pb i am real novice in excel, so f.e when i try with 1value it works well but as long as i try to put more values it just wont work =IF(I5="Frederick";Products!I3;Products!I6) works =IF(I5="Frederick","Karim";Products!I3;Products!I6 ) -- mr_teacher ------------------------------------------------------------------------ mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352 View this thread: http://www.excelforum.com/showthread...hreadid=573381 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
How do I move excel address lists to outlook. and vice versa. | Excel Discussion (Misc queries) | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
How can I get an address in one cel and vertical? | Excel Discussion (Misc queries) | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions |