| 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 |
| 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) | |||
Threaded Mode
