 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2006Taking a value 3 columns right
Hi, I have, A1: 1 D1: 2 How do I write the function that if say A1="1", then G1 will take whatever value that is 3 collumns to the right of cell A1 (in this case, "2"). Appreciate any help on this! Thanks! Enter this formula in G1: =IF(A1=1,D1,"") You don't specify what you want to happen if A1 is not equal to 1, so I have assumed you want the cell to remain blank. Hope this helps. Pete > Hi, > [quoted text clipped - 7 lines] > > Appreciate any help on this! Thanks! Thanks Pete, I actually have a long list of number in a column. For example A1:0.8 D1:2 A2:1.0 D2:3 A3:1.2 D3:8 An: xx Dn: xx n is integer and xx is random number If I enter in cell E1 as "1.2", I need cell G1 to display number 8. Is that possible? > Enter this formula in G1: > [quoted text clipped - 18 lines] > > > > Appreciate any help on this! Thanks! Have a look at my reply to your other post - use VLOOKUP to do this. Pete > Thanks Pete, > [quoted text clipped - 35 lines] > > > > > > Appreciate any help on this! Thanks! Thanks a lot! :) > Have a look at my reply to your other post - use VLOOKUP to do this. > [quoted text clipped - 39 lines] > > > > > > > > Appreciate any help on this! Thanks! You're welcome. Pete > Thanks a lot! :) > [quoted text clipped - 41 lines] > > > > > > > > > > Appreciate any help on this! Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.