Lookup

[brandon16]

Hi,

I need to do a lookup on 2 values, a variable name and date then populate with a value, any idea how I go this please?

Table is currently like this

[TABLE="width: 378"]
<colgroup><col width="63" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 63"][/TD]
[TD="class: xl72, width: 63, align: right"]201701[/TD]
[TD="class: xl72, width: 63, align: right"]201702[/TD]
[TD="class: xl72, width: 63, align: right"]201703[/TD]
[TD="class: xl72, width: 63, align: right"]201704[/TD]
[TD="class: xl72, width: 63, align: right"]201705[/TD]
[/TR]
[TR]
[TD="class: xl68"]A[/TD]
[TD="class: xl68, align: right"]2[/TD]
[TD="class: xl68, align: right"]43122.9[/TD]
[TD="class: xl68, align: right"]4[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: right"]52[/TD]
[/TR]
[TR]
[TD="class: xl68"]B[/TD]
[TD="class: xl68, align: right"]49[/TD]
[TD="class: xl68, align: right"]34534[/TD]
[TD="class: xl68, align: right"]45[/TD]
[TD="class: xl68, align: right"]4544[/TD]
[TD="class: xl68, align: right"]65[/TD]
[/TR]
[TR]
[TD="class: xl68"]C[/TD]
[TD="class: xl68, align: right"]34[/TD]
[TD="class: xl68, align: right"]545454[/TD]
[TD="class: xl68, align: right"]43122.9[/TD]
[TD="class: xl68, align: right"]567[/TD]
[TD="class: xl68, align: right"]52[/TD]
[/TR]
[TR]
[TD="class: xl68"]D[/TD]
[TD="class: xl68, align: right"]4[/TD]
[TD="class: xl68, align: right"]33[/TD]
[TD="class: xl68, align: right"]3343[/TD]
[TD="class: xl68, align: right"]44[/TD]
[TD="class: xl68, align: right"]5888[/TD]
[/TR]
[TR]
[TD="class: xl68"]E[/TD]
[TD="class: xl68, align: right"]345446[/TD]
[TD="class: xl68, align: right"]45[/TD]
[TD="class: xl68, align: right"]444455[/TD]
[TD="class: xl68, align: right"]66[/TD]
[TD="class: xl68, align: right"]52
[/TD]
[/TR]
</tbody>[/TABLE]


I want a look up to put the values in a table like this

[TABLE="width: 204"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD="align: right"]201701[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]201701[/TD]
[TD="align: right"]49[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]201701[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]201701[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]201701[/TD]
[TD="align: right"]345446[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]201702[/TD]
[TD="align: right"]43122.9042[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]201702[/TD]
[TD="align: right"]34534[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]201702[/TD]
[TD="align: right"]545454[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]201702[/TD]
[TD="align: right"]33[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]201702[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]201703[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]201703[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]201703[/TD]
[TD="align: right"]43122.9[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]201703[/TD]
[TD="align: right"]3343[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]201703[/TD]
[TD="align: right"]444455[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]201704[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]201704[/TD]
[TD="align: right"]4544[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]201704[/TD]
[TD="align: right"]567[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]201704[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]201704[/TD]
[TD="align: right"]66[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]201705[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]201705[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]201705[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]201705[/TD]
[TD="align: right"]5888[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]201705[/TD]
[TD="align: right"]52
[/TD]
[/TR]
</tbody>[/TABLE]

Any idea what formula I would use please?

Thanks

 

[jproffer]

https://www.mrexcel.com/forum/excel-questions/1044107-transpose-data-i-think.html

isn't this the same question as another one you posted earlier?

Not complaining, just.....did their suggestions not work for you?

 

[brandon16]

It is yes, the suggestions didn't work and I didn't want to dive into a macro as have no experience. I was hoping there would be a different way to format the table and felt that If I didn't start a new thread, I wouldn't be able to get the answer I hoped for.

 

[jproffer]

Fair enough, just wondered.

You have a recent reply on your original thread, that...I'm just assuming, by who responded...will probably work for you.

 

[hiker95]

brandon16,

In your other thread, my reply #9, contains a macro that will do what you have requested.

I can change the macro if you would like the results to be in a new worksheet, or, in another worksheet?

 

[Fluff]

Duplicated https://www.mrexcel.com/forum/excel-questions/1044107-transpose-data-i-think.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).