LOOK UP/VLOOKUP
 

Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.

LOOK UP/VLOOKUP
 

What do you mean - "sorted by time" ?

Give some examples of what you want to achieve.

Pete

On Dec 12, 10:50*am, Sasikiran
wrote:
Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.

LOOK UP/VLOOKUP
 

Hi Pete,

For suppose i enter column details for column headers like meeting date,
time, name, w, x, y,z in sheet 1. In sheet 2 if i give a search by the
meeting date, I want to get the entries made for that specific day sorted by
time and the respective column details.

The entries in sheet 1 will not be in an increasing time, but when i give a
search in sheet 2, the details should get listed in ascending time format.

Also I would be requiring only column details of selected column headers in
sheet 2 and not all entered in sheet 1.

Hope this is clear.


"Pete_UK" wrote:

What do you mean - "sorted by time" ?

Give some examples of what you want to achieve.

Pete

On Dec 12, 10:50 am, Sasikiran
wrote:
Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.

LOOK UP/VLOOKUP
 

Hi Pete,

Hope my request is clear enough.

Please suggest for some other alternative.

Thanks in advance.


"Sasikiran" wrote:

Hi Pete,

For suppose i enter column details for column headers like meeting date,
time, name, w, x, y,z in sheet 1. In sheet 2 if i give a search by the
meeting date, I want to get the entries made for that specific day sorted by
time and the respective column details.

The entries in sheet 1 will not be in an increasing time, but when i give a
search in sheet 2, the details should get listed in ascending time format.

Also I would be requiring only column details of selected column headers in
sheet 2 and not all entered in sheet 1.

Hope this is clear.


"Pete_UK" wrote:

What do you mean - "sorted by time" ?

Give some examples of what you want to achieve.

Pete

On Dec 12, 10:50 am, Sasikiran
wrote:
Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.

LOOK UP/VLOOKUP
 

I don't usually post at weekends, and I think we have a big time
difference anyway, so please bear with me until Monday.

Pete

On Dec 13, 6:45*am, Sasikiran
wrote:
Hi Pete,

Hope my request is clear enough.

Please suggest for some other alternative.

Thanks in advance.



"Sasikiran" wrote:
Hi Pete,

For suppose i enter column details for column headers like meeting date,
time, name, w, x, y,z in sheet 1. In sheet 2 if i give a search by the
meeting date, I want to get the entries made for that specific day sorted by
time and the respective column details.

The entries in sheet 1 will not be in an increasing time, but when i give a
search in sheet 2, the details should get listed in ascending time format.

Also I would be requiring only column details of selected column headers in
sheet 2 and not all entered in sheet 1.

Hope this is clear. *

"Pete_UK" wrote:

What do you mean - "sorted by time" ?

Give some examples of what you want to achieve.

Pete

On Dec 12, 10:50 am, Sasikiran
wrote:
Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.- Hide quoted text -

- Show quoted text -

LOOK UP/VLOOKUP
 

You can send me a sample file (.xls NOT .xlsx) to:

pashurst <at auditel.net

Indicate which columns you want to see in your second sheet.

Pete

On Dec 13, 6:45*am, Sasikiran
wrote:
Hi Pete,

Hope my request is clear enough.

Please suggest for some other alternative.

Thanks in advance.



"Sasikiran" wrote:
Hi Pete,

For suppose i enter column details for column headers like meeting date,
time, name, w, x, y,z in sheet 1. In sheet 2 if i give a search by the
meeting date, I want to get the entries made for that specific day sorted by
time and the respective column details.

The entries in sheet 1 will not be in an increasing time, but when i give a
search in sheet 2, the details should get listed in ascending time format.

Also I would be requiring only column details of selected column headers in
sheet 2 and not all entered in sheet 1.

Hope this is clear. *

"Pete_UK" wrote:

What do you mean - "sorted by time" ?

Give some examples of what you want to achieve.

Pete

On Dec 12, 10:50 am, Sasikiran
wrote:
Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.- Hide quoted text -

- Show quoted text -

LOOK UP/VLOOKUP
 

Dear Pete,

I am unable to send the sample .xls file to "pashurst <at auditel.net"

Please mention an alternate email ID.


"Pete_UK" wrote:

You can send me a sample file (.xls NOT .xlsx) to:

pashurst <at auditel.net

Indicate which columns you want to see in your second sheet.

Pete

On Dec 13, 6:45 am, Sasikiran
wrote:
Hi Pete,

Hope my request is clear enough.

Please suggest for some other alternative.

Thanks in advance.



"Sasikiran" wrote:
Hi Pete,

For suppose i enter column details for column headers like meeting date,
time, name, w, x, y,z in sheet 1. In sheet 2 if i give a search by the
meeting date, I want to get the entries made for that specific day sorted by
time and the respective column details.

The entries in sheet 1 will not be in an increasing time, but when i give a
search in sheet 2, the details should get listed in ascending time format.

Also I would be requiring only column details of selected column headers in
sheet 2 and not all entered in sheet 1.

Hope this is clear.

"Pete_UK" wrote:

What do you mean - "sorted by time" ?

Give some examples of what you want to achieve.

Pete

On Dec 12, 10:50 am, Sasikiran
wrote:
Dear All,

Can you help me with the LOOK UP/VLOOKUP function?

Let me explain my requirement clearly.

In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.

For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that date should appear in the column
range (B4:G4) of the same sheet sorted by time.

Please help me.- Hide quoted text -

- Show quoted text -