vlookup on date to text

R

RC

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
 
P

PCLIVE

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
 
Top