G
Guest
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
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