Vlookup + CHOOSE functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using a Vlookup table
named range:"xfactory
xfactory weekday day
cambodia Thursday
china Friday
Mauritius Tuesday
Mongolia Thursday
thailand Saturday
Turkey Thursday

named range: "weekday

MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
SUNDAY

named range: "formula

Friday Choose(weekday(F33+1),5,4,3,2,1,0,6)
Saturday Choose(weekday(F33+1),6,5,4,3,2,1,0)
Thursday Choose(weekday(F33+1),4,3,2,1,0,6,5)
Tuesday Choose(weekday(F33+1),2,1,0,6,5,4,3)

On sheet 1, cell f34 should equal F33 (formatted as date) + 1 day BUT the day itself should fall on the day based on criteria in named range "xfactory"; which will be at least 1 day more than F33. The country is selected by using a combo box (linked cell) in cell D2
I tried using the following formula:
=(F33+1)+VLOOKUP(F4,formula,2,FALSE
but my result is a #VALUE! error

Ex. f33=2/5/0
f34 = should equal 2/7/04 (if the criteria were a Saturday
Is there a way to do this

Thanks in advance!
 
Hi Marcy
not sure what you are trying to achieve. But it looks a little bit too
complicated converting days multiple times. In addition in your example
what value is stored in F4. Maybe you can clarify your issue a little
bit more.
If you like, you can email me your spreadsheet and I'll have a look at
it

Frank
 
Sorry about the incomplete details. but, I am happy (and a little bit tickled with myself) that I was able to figure it out myself!!

I know I couldn't have gotten this far without the help, support and instruction from this fantastic newsgroup!!

Kudos to the great teachers in here; and yippee for me, the long-time student!
 
Back
Top