P
Patrick C. Simonds
I have the following table (A1:B6) from which I want to return the
appropriate value from column 1. This is my formula:
VLOOKUP(R16,'Sunday (3)'!A1:B6,1,TRUE)
My problem is that if R16 contains AIL, Floating Holiday, LWOP, Regular
Holiday the formula returns #NA, Sick returns NW6 not NW5 and Vacation
returns the correct value NW6.
As a test I tried swapping Vacation and LWOP and but Vacation Still returned
the NW6 value.
A B
1 NW1 AIL
2 NW2 Floating Holiday
3 NW3 LWOP
4 NW4 Regular Holiday
5 NW5 Sick
6 NW6 Vacation
appropriate value from column 1. This is my formula:
VLOOKUP(R16,'Sunday (3)'!A1:B6,1,TRUE)
My problem is that if R16 contains AIL, Floating Holiday, LWOP, Regular
Holiday the formula returns #NA, Sick returns NW6 not NW5 and Vacation
returns the correct value NW6.
As a test I tried swapping Vacation and LWOP and but Vacation Still returned
the NW6 value.
A B
1 NW1 AIL
2 NW2 Floating Holiday
3 NW3 LWOP
4 NW4 Regular Holiday
5 NW5 Sick
6 NW6 Vacation