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

 

[sprakash1704]

A3:l23

 

[gaz_chops]

Try this in the 1st cell, copy down & across
=iferror(INDEX($B$5:$L$22,MATCH($N7,$A$5:$A$22,0),MATCH(O$6,$B$2:$L$2,0)),"")

 

[fairchance]

This message is for Sir gaz_chops. I have posted a thread with the name of "Macro needed". I need your help sir

 

[sprakash1704]

Hi Gaz,

Its working but partially, when I input Sep in "O6" it gives me Oct data for the emp !!!

 

[sprakash1704]

Sorry Gaz,

I guess I made a mistake, I think its working, let me check!

 

[sprakash1704]

Oh My Gaz!

You made my day, super man!, Thanks A Ton, It worked!

 

[gaz_chops]

Lol you're welcome, got there in the end.

 

[sprakash1704]

Hey Gaz,Good day,

you there, I am stuck in a formula!!!

 

[gaz_chops]

Good morning, whats up?

 

[sprakash1704]

Oh! Gaz, Good Morning!,

Am glad you are here!

I have a similar query, need help.
How to Vlookup between two sheets with different headers
I have name in the row and months (Jan, Feb, Mar . . .) in column in one sheet(Sheet1) and on the other sheet(Sheet2) I have name and months but with different header (January, February, March . . .) and I need to extract the data for Mar from Sheet1 for an employee in March column in sheet 2, the glitch here is, I might not have constant months in both the sheets, for eg I might have in sheet2 February and June alone so I don't think the usual Vlookup will work. Experts please assist !!!

Kind Regards,
Prakash