joshbjames
New Member
- Joined
- Jul 25, 2017
- Messages
- 33
Is there a formula that I could use in B1 that labels the column "Date" as well as applies a VLOOKUP formula for the whole column? Please forgive this atrocious question. I'm having a hard time figuring out how to word this for clarity... My goal is to have a sheet that automatically populates when I paste values into column A
<tbody>
</tbody>
orderID | Label="Date" & formula =vlookup(A:A,dateListA:B,2,false) |
00001 | 01/02/18 |
00002 | 02/03/18 |
00003 | 03/04/18 |
00004 | 04/05/18 |
00005 | 05/06/18 |
<tbody>
</tbody>