Wednesday, March 30, 2016

Troubleshoot:a formula which reads "whatever is in the cell above, but one column over"...

a formula which reads "whatever is in the cell above, but one column over"...

Or the question could read, "pull part of the formula from an adjacent cell and find the corresponding cell on a different worksheet"

Hello,

In Cell C11 I have =Sheet2!A1, which happens to be a date.
Now, in C13 I want to have the answer from Sheet2!B1.
 Easy.
=Sheet2!B1.

However, it is likely that C11 will be changed.
 There is a ready made alternative, which comes from a bunch of options already referenced on sheet1!, which can be pasted in.
 This is purely personal arbitrary (depending on other factors), so, a user could
paste into C11 the contents of cell C55 (which is looking up =Sheet2!A15 instead, for example).
 In which case I want C13 to read =Sheet2!B15.
 Basically I don't trust the user to change both the start time as well as end time, so I want the end to correspond
with what is in the cell above automatically.

I want C13 to adjust automatically depending what is in C11.
 For example, C13 would read "what is one column to the right of the formula in C11."

Does that make any sense at all?  I am tired, I think I need to come back to this again tomorrow, or in a week!

Andy

Solutions to the Problem a formula which reads "whatever is in the cell above, but one column over"...

Download Error Fixer (Free)

It appears to me that what you really need is a lookup.  Instead of using =Sheet2!A1 to enter the value in C11 you could just type the date in that cell and then use a VLOOKUP() formula in cell C13, e.g.
=VLOOKUP(C11,Sheet2!A1:B20,2,FALSE)
(assuming your list of dates is in cells A1 to B20 on Sheet2).

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Recommended Method to Fix the Problem: a formula which reads "whatever is in the cell above, but one column over"...:

How to Fix a formula which reads "whatever is in the cell above, but one column over"... with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.


Related: [Solved] Applications have stopped working with SP1 on Windows 7!,[Solved] I can't find auto complete text in word 2007,[Solution] I need to keep reinstalling eHome Infrared Transceiver driver everytime my computer shuts down.,How to Resolve - system restore not working windows 7?,Unable to open embedded word file on the intranet. [Solved],Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: [Solution] a client can't preview certain excel file,but can preview other excel files.,Action Center - How to remove Obsolete message [Solved],A problem with Internet Explorer,Troubleshooter of Error: A fixed Blue Screen with possible problems,[Anwsered] Activation code for Flight Simulator X Deluxe Editon not working,Cannot delete empty file icon on desktop...,Cannot download flashplayer,can't get the CIA review progrom install which is an older version,Cannot access one website-DNS server not responding.,Can't Receive or Send Vista Windows Mail - Router stopped recognizing DSL connection & wants to dial up

No comments:

Post a Comment