V look up

[sharath prasad]

Hi

I have in Sheet 1 a table of 3 columns showing

Column A = From Date
Column B = To Date
Column C = Employee who should manage the shift . His Employment number is entered here.


In Sheet 2 i have Invoice dates in Column A.

For each dates in column A, i want to enter the Employee Number against each date in Column B . This value is obtained form Sheet 1..


Can i use V Look up ..how ?


Can i use V look up or can u help me with any code


Please help

 

[RonEmm]

Sharath,

In column B of sheet 2 you should enter the following formula:

=VLOOKUP(A2,Sheet1!$A$2:$C$45,3,0)

where:
- A2 is the date in colums A of sheet 2 you want to looup;
- Sheet1!$A$2:$C$45 in the table you want to look in;
- 3 in the 3rd column of the above table. This column contains the output for bolumn B of sheet 2;
- 0 stands for the exact value you want to retrieve.

Otherwise check the helpfiles for more explanation.

I am not able to post a example sheet for your convenience.

Good luck with it.

Ronald

 

[sharath prasad]

Thank you very much.
It worked perfect to my problem

Have a nice day