Question description:
This user has given permission to use the problem statement for this
blog.
I need to build a table where i can enter dates in column A, and column B identifies the pay code used that day was based on data in the second sheet (on the second sheet, the date, and the paycode are in columns a and b respectively).
Solved by F. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
20/08/2017 - 07:25
Nope
User
20/08/2017 - 07:25
not yet ayway
Excelchat Expert
20/08/2017 - 07:25
Welcome, Thanks for choosing Got It Pro-Excel
Excelchat Expert
20/08/2017 - 07:26
you does not upload sheet with data
User
20/08/2017 - 07:26
no i haven't
Excelchat Expert
20/08/2017 - 07:27
the 2nd shet is like that I add
User
20/08/2017 - 07:27
Yes
User
20/08/2017 - 07:27
I can quickly type it out if that is easier
Excelchat Expert
20/08/2017 - 07:27
can you fill some data
User
20/08/2017 - 07:27
sure
Excelchat Expert
20/08/2017 - 07:28
now you want in sheet 1
Excelchat Expert
20/08/2017 - 07:29
when you enter one of the dates to display code in same row in column b
Excelchat Expert
20/08/2017 - 07:30
on column e
User
20/08/2017 - 07:31
Column, c and d come from manual entry but E i'd like to pull from Column B on the second sheet, based on the data points i entered in A
Excelchat Expert
20/08/2017 - 07:31
ok give me moment to see and solve
Excelchat Expert
20/08/2017 - 07:34
Entering Explanation Phase
Excelchat Expert
20/08/2017 - 07:35
thats will work
Excelchat Expert
20/08/2017 - 07:37
but if there is no code associte with date what the result you want to done
Excelchat Expert
20/08/2017 - 07:37
hello
User
20/08/2017 - 07:38
in the table that i'm building, ever date i enter in column A will have a point of data on the second sheet
Excelchat Expert
20/08/2017 - 07:38
in order that there is no code we use that
User
20/08/2017 - 07:39
?
Excelchat Expert
20/08/2017 - 07:40
if you does not enter date error will appear
Excelchat Expert
20/08/2017 - 07:40
To prevent the error from appearing
User
20/08/2017 - 07:40
ok so until i have column A complete, E on this sheet with show an error
Excelchat Expert
20/08/2017 - 07:41
look if you enter wrong date
Excelchat Expert
20/08/2017 - 07:41
now is it clear
User
20/08/2017 - 07:42
ok
Excelchat Expert
20/08/2017 - 07:42
are you have any other question
Excelchat Expert
20/08/2017 - 07:43
Entering Discussion Phase
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.