Conditional Vlookup with Populate

[phoztek]

Hi all

Have been learning so much in this forum and its good to have so many helpful ppl.

And here i am again with some doubts and in need of help.

Tryed to use a conditional Vlookup to get some date from a matrix but having trouble to populate.

I'll leave an example bellow, all help is welcome


Thanks so much

[venkat1926]

I suggest you DO NOT MERGE cells when you are doing vba. Merging gives some problems.
I have removed merging.

now select the first cell in your erstwhile merged range
for e.g A12
click the button in the sheet
similarly select c12 and click the
or E12 or A19,C19 or E19

Keep the original data safely form somewhere

the macro which is invoked by the button is called "test" and given below (also available in the attached file's vbeditor)

Please Login or Register  to view this content.

Instead of merging, if necessary select the necessary range e.g. A12:B16 and format -borders with thick line or colored line

CONFIRM IF THIS IS OK

[phoztek]

Hello Venkat, thanks for the reply.

Well i tryed the code and it looks like it does a good job, but is there a way to Auto-populate?

And is this only possible using VBA script ?

Couldn't a Vlookup with If do the trick ?

And for example if i have multiple inputs for the same day ?

Thanks for your help

[phoztek]

So any more help ?

How do i auto populate without using the button?

Thanks in advance