VLOOKUP WEEKDAY Function

Hi,

I am editing an excel sheet with plenty of dates and have found this line of code. Can someone please explain what it means?

=X9+VLOOKUP(WEEKDAY(X9,2),{2,4;6,3},2,0)

I know that it is looking up the adjacent cell (X9), and if that value is a TUE, it adds 4 on to the date to return a Saturday, if it is a SAT it adds 3 on to return a TUESDAY.

2,4 = if Weekday 2 (Tuesday), +4
6,3 = if Saturday 6 (Saturday), +3

but what does the 2,0 mean?

Thanks,
Andy

2 in the vlookup function is column index. If the value in the first column of your (2 or 6), it will return the corresponding value in the second column (4 or 3)

0 is the match type of vlookup. It will match the exact value. You have other match types 1(less than) or -1(Greater than)