| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking a specific x/y position in a table (appended)
The term "Then" is used only in VBA code. In a worksheet formula, "Then" is implied... If("The cat is black", "Avoid It", "Feed It")... -or- If(True, do if true, do if false) There are two separate help files, one for vba programming and one for Excel. Look in the Excel Help file under "If Function". Also, helpful advice here... http://www.cpearson.com/excel/newposte.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "TheMilkGuy" wrote in message Thanks Jim, vlookup works just fine! My next issue is the if/then series of input variables... I have read about IF, but there doesn't seem to be a THEN command. If I have a drop-down box in cell A2 that has 3 variables, can an formula be set up that will determine which data sheet will be used based on the number selected in that A2 drop-down box? IE: if A2=500, then use the "500" chart on Sheet3 Thanks! Craig On Aug 15, 6:58 am, "Jim Cone" wrote: Suggest you start with the VLookup function which will find a value in a table column and return the value from another column. It is explained in Excel help. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I obtain position of specific value in a row of numbers | Excel Worksheet Functions | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
| Replacing a specific position in a cell with something else | Excel Discussion (Misc queries) | |||
Threaded Mode
