RoganLogan
New Member
- Joined
- Dec 7, 2011
- Messages
- 45
Hi Guys, This is probably pretty simple but I’m struggling to figure it out.
I have column of prices that are applicable to a column of months and years.
I also have to enter a date and time into cell F6 in the following format 05/04/2021 11:00:00. This format cant be changed.
I am trying to use a vlookup to bring the relevant price from column Q and place it in cell D16 for the month and year from the date format in cell F6. I have tried using a helper cell with
=TEXT(F6,"mmm")&"-"&TEXT(F6,"yy") to extract just the year and month but the vlookup still doesn’t work and I’m getting the #N/A result.
Any help would be greatly appreciated. Thanks
I have column of prices that are applicable to a column of months and years.
I also have to enter a date and time into cell F6 in the following format 05/04/2021 11:00:00. This format cant be changed.
I am trying to use a vlookup to bring the relevant price from column Q and place it in cell D16 for the month and year from the date format in cell F6. I have tried using a helper cell with
=TEXT(F6,"mmm")&"-"&TEXT(F6,"yy") to extract just the year and month but the vlookup still doesn’t work and I’m getting the #N/A result.
Any help would be greatly appreciated. Thanks