| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number and date
"Claus Busch" wrote in message ... Hi, Am Mon, 11 May 2015 07:03:09 +1000 schrieb RamRodOz: (D-1) 20 (D-2) 50 (D-3) 10 (E-1) 5/1/2015 (E-2) 6/4/2015 (E-3) 7/5/2014 try: =VLOOKUP(A1,D1:E100,2,0) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional Many thanks Yes it works --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula concatenating date & text converts date to number | Excel Programming | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| changing date formatted as general number into date format | Excel Programming | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
Threaded Mode
