**Re: How to lookup a value in a column of data not in ascendi**

Hi,

Try Vlookup.

To make things really easy, hightlight both column Friday and shift (assuming that they are side by side) and give it a name in the namebox (Upper left hand corner, right above cell A1). Call it FRIDAY.

=VLOOKUP(A3,FRIDAY,2)

this will lookup the employee name in Friday (must be the far left column) and return the employees' shift, which is what the 2 represents, the second column.

Suppose you had something like ths for the whole week. Mon - Fri. Counting the employees' name, that would be a total of six columns. Highlight the whole six columns and 50 rows and call it SHIFTS.

For Monday =VLOOKUP(A3,SHIFTS,2)

For Tuesday = VLOOKUP(A3,SHIFTS,3)

and so on.

Hope this helps.

Ron