Using formula how to extract data depending on two values

[sprakash1704]

Dear Experts!

Relatively I am new to this forum, when I say relatively, I have been using this forum just to search and get answers for all my excel related queries for almost 6 years now and haven't posted anything or even registered. Thanks to all the experts who have helped me so for!

The question I have here is based on the table provided below. The data and headers in the column is fluctuating as this is a pivot, I will need to refer the pivot and will be extracting the required data based on "Emp ID". Need Help in doing this by formula, as I am not coding expert and I love working with formulas.

Experts I require this quite urgently, so please help!!!!!

Emp ID	Jan	Feb	Mar	Jul	Aug	Sep	Oct	Nov	Dec
22705	4888.47		195.3	5170.18	5635.55	5263.22	6038.22	4787.53	5081.35
31799		5487.5		1388.69	1314.11	1182.74	1311.87	712.1	1807.24
39974	4063.28			6090.46	4595.35	7673.24	7280.15	3753.64	4459.22
57683	4212.66	159.42		4363.84	4372.54	4251.25	5323.53	4084.27	4063.28
57794				5569.82	5751.9	5696.69	6038.89	4378.91	4467.81
61546		40.19		4733.94	4664.96	3729.11	5026.33	4609.51	5487.5
61547	2435.05			5086.47	5191.55	4810.99	3932.63	4715.96	4212.66
66751	4467.81			5979.45	5475.14	2220.97	5752.75	3794.56	4888.47
71060		5512.42		2014.37		1786.68	2434.34	2175.93	1375.38
77571		50.21		4799.73	7239.91	6204.31	5383.25	4883.97	5300.31
90537			126.44	4909.14	4511.42	5032.8	5749.05	2075.37	5066.75

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

Kind Regards,
Prakash

 

[gaz_chops]

You're welcome.

 

[sprakash1704]

Just out of curiosity, is there any other option to do this without the temp table for vlookup ?

 

[gaz_chops]

It is generally much easier to manage any changes/additions to the table.
How many are in the lookup table, are they likely to increase/change?

 

[sprakash1704]

Sorry Gaz, missed your msg , as of now its just 10 rows !

 

[sprakash1704]

Hey Gaz, just a quick question on the match formula, how do I use trim in match, coz I tried and its not working

 

[sprakash1704]

np, I used Ctrl + Shift + Enter and used trim and its working

 

[gaz_chops]

I really would stick with the table, but alternative is like
=INDEX(Sheet1!$A$1:$E$14,MATCH($A2,Sheet1!$A$1:$A$14,0),MATCH(LOOKUP(B$1,{"Consumer Electronics","Online Store","Supercenter","Superstore",""},{"Bestbuy","Amazon","Walmart","Target"}),Sheet1!$A$1:$E$1,0))