lookup value if it match a criteria.

**coolhit** · 07-30-2009, 05:44 AM

Hi,

Please can someone help with lookup.

As its very new thing for me to do lookup like this one.

I have attached file if you could assist me.

User enters Date in "Bookings DAY COMPILER" sheet cell F2 and press the buttton.

Macro looks up the date which user has entered and matches the date in "Booking IN CALENDAR" and bring over column B(time) and C(delivery ref) in "Bookings DAY COMPILER" in B5(Time) and C5(Delivery Ref).

Please can someone assist me.

Many Thanks in advance.

**StephenR** · 07-30-2009, 07:31 AM

Try this:

Please Login or Register  to view this content.

**coolhit** · 07-30-2009, 07:06 PM

Originally Posted by StephenR

Try this:

Please Login or Register  to view this content.

Thankyou for the above code, works great. Could i ask for small favour.
if i want to extact other columns what part of codeing do i change or add.
Currently is does column B,C&D and if i want to add column H,K,M&N.

Once again many thanks.

**coolhit** · 07-31-2009, 04:17 AM

Originally Posted by coolhit

Thankyou for the above code, works great. Could i ask for small favour.
if i want to extact other columns what part of codeing do i change or add.
Currently is does column B,C&D and if i want to add column H,K,M&N.

Once again many thanks.

PLease could someone assist me with above.

**Andy Pope** · 07-31-2009, 05:39 AM

Use the OFFSET approach again,

not tested so resize or offset indexes may be out

Please Login or Register  to view this content.

**coolhit** · 07-31-2009, 06:12 AM

Originally Posted by Andy Pope

Use the OFFSET approach again,

not tested so resize or offset indexes may be out

Please Login or Register  to view this content.

I tried this didn't work. Does column B,C&D from row 5 but H,K,M:N goes down from the last entry of BCD creating step effect going downwards.

Any ideas as i am new to resize and offset

**Andy Pope** · 07-31-2009, 06:27 AM

Please Login or Register  to view this content.

Once column B is populated with data from the first copy the row position is out of sync. So a new object, rngOut, is used to maintain the same output point.