Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup on date to text
I want to use a vlookup to get a value for a day of the week where the lookup
value (cell V3) is provided by =TEXT(V4,"dddd"). The first column in the table is text and I keep getting a #VALUE error using the following syntax VLOOKUP(V3,$V$48:$W$54,1). Do I need to have a formatting function in the vlookup or format the target table's text days differently? Thanks |
#2
|
|||
|
|||
vlookup on date to text
I'm not sure why you'd be getting the #VALUE error. It seems to work fine
on my side. I'm assuming your the first column of your table consists of Sunday through Saturday. Make sure your table is sorted by the first column. Other than that, you can combine formula as follows: =VLOOKUP(TEXT(V4,"dddd"),$V$48:$W$54,1) HTH, Paul "RC" wrote in message ... I want to use a vlookup to get a value for a day of the week where the lookup value (cell V3) is provided by =TEXT(V4,"dddd"). The first column in the table is text and I keep getting a #VALUE error using the following syntax VLOOKUP(V3,$V$48:$W$54,1). Do I need to have a formatting function in the vlookup or format the target table's text days differently? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on large text in cells | Excel Worksheet Functions | |||
Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
vlookup multiple text rows | Excel Discussion (Misc queries) | |||
Vlookup a value and text | Excel Discussion (Misc queries) | |||
merge unformatted date with text | Excel Discussion (Misc queries) |