Getting value from 2 cols right, 1 row down

H

Handyy

Hi,

I guess this is a simple question but I couldn't figure out how to ge
around it.


Code
-------------------
A B C D E F
1 Worker 100 100 100 100
2 110 110
3 Worker 120 120 120
4 130 130 13
-------------------


Sheet above is a work schedule and 100, 110, 120 and 130 are jus
predefined work shifts. Row 1 is a morning shift row and Row 2 is
night shift row for the first worker.

Now what I want to do is to create another sheet with workers names t
make statistical analysis so that I only would enter workers name an
it would show his/hers work shifts.

I already got morning shifts right with VLOOKUP but as the night shift
are one row below workers name I can't get it right. Can you somehow us
VLOOKUP to look a value example 2 columns right and 1 row down
 
J

jirkalla

Hi Handyy,
I would recommend Pivot Table - first you need to consolidate data source
(each row must have a Worker name), then it will be very easy to analyse your
data.
j
 
I

Ivan Raiminius

Hi Handyy,

try using combination of "offset" and "match" functions.

Regards

Ivan
 
Top