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!!!!!



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


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