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

	201701	201702	201703	201704	201705
A	2	43122.9	4	7	52
B	49	34534	45	4544	65
C	34	545454	43122.9	567	52
D	4	33	3343	44	5888
E	345446	45	444455	66	52

<colgroup><col width="63" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

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

A	201701	2
B	201701	49
C	201701	34
D	201701	4
E	201701	345446
A	201702	43122.9042
B	201702	34534
C	201702	545454
D	201702	33
E	201702	45
A	201703	4
B	201703	44
C	201703	43122.9
D	201703	3343
E	201703	444455
A	201704	7
B	201704	4544
C	201704	567
D	201704	44
E	201704	66
A	201705	52
B	201705	65
C	201705	52
D	201705	5888
E	201705	52

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

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).