|
|
#1
05-18-2016, 04:51 PM
|
|||
|
|||
Relational results
I wish to do the following:
Enter a date value in cell A1 Automatically locate the corresponding date in column B1:B6 Display the corresponding value in column C1:C6 in Cell D1 See attachment Thanks for any and all assistance scrn.jpg 
|
|
#2
05-18-2016, 06:42 PM
|
|||
|
|||
|
Try
=LOOKUP(A1,B1:B6,C1:C6)
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Vlookup returns inconsistent results | Jhnsnkth527 | Excel | 0 | 04-16-2015 12:36 PM |
| 2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |
 Outlook search too many results
|
alexb123 | Outlook | 1 | 10-10-2013 09:53 AM |
|
Bookmarking Formula Results
|
Wyskers | Word | 3 | 11-09-2012 01:13 PM |
| Search results disappearing | Emerogork | Office | 3 | 07-17-2011 03:52 PM |
Windows 7 64bit 
Office 2013
Linear Mode
