Solution to Problem: Column value, based on last value in another column

Column value, based on last value in another column

Column A has a list of 100 consecutive dates; past, present, and future.  In column B monthly values are posted.  I need a formula that gives the date in Column A corresponding to the last posted value in column B.

Solutions to the Problem Column value, based on last value in another column

Download Error Fixer for Free Now

Column B values are currency.

Ok, try this version (although the other one will work just as well)...
=LOOKUP(1E100,B1:B100,A1:A100)
Format as Date
--
Biff
Microsoft Excel MVP

This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Column value, based on last value in another column.

  1. Back-up the Registry of your operating system.
  2. Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
  3. Note: this Registry Key should already exist, if it does not exist, create it.
  4. Create a brand new DWORD Value that is named AllowOsUpdate
  5. Set the Value to 0x00000001.
  6. Close and reopen your Control Panel.
  7. Restart the Microsoft Windows.

Recommended Method to Fix the Problem: Column value, based on last value in another column:

How to Fix Column value, based on last value in another column with SmartPCFixer?

1. Download SmartPCFixer. Install it on your system.

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

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


Related: Cannot Access Favorites,Cannot Install I Tunes Or Quick Time Player,Cannot Disable Local Area Network,Cannot Find My Internet Explorer 8 Tool Bar,Can't Update/download And Problems With Antivirus Software.,Cannot Run A Server Based Program On Windows 7 Machine,Cannot: Access Internet Options; Download Files; Allow 'Temporary Pop-Ups; And I've Lost The Favourites Toolbar!,Cannot Save Or Save As A Document That We've Worked On Before,Cannot Start Up In Safe Mode,Cannot Unpin Uninstalled Program From Taskbar,Cant Install Any New Programs...Help!!,Capturing Running Processes On Windows OS.,Change Chart With Secondary Axis From Stacked To Cluster,Click-To-Run Application Manager (x) Microsoft Word Starter 2010 Cannot Be Opened. Try Again Or Repair The Product In The Control Panel,Can´t Install Programs - Either No Access To Temp Folder Or Windows Installer Denies Service Depends On Program To Install
Read More: How to Fix Problem - Cant paste into formula bar excel 2007.?,Troubleshoot:cell won't hold decimal point, excel 2007 Error,[Anwsered] cant display this web page,[Anwsered] change external hard drive type from local disk to removable,Cant find a program I downloaded [Solved],Can send email but cannot reply or forward emails,Cannot establish an account with Winqual as the site does not have this link,Cannot access any programs and icons changed to e(explorer),Cannot connect to Router via wireless or Ethernet cable unless router is unplugged and replugged.,CD formatted in CDFS won't open> says no program asssoicated
[PR]
by FileWriteError22 | 2016-09-19 17:29