Get values from a range based on certain conditions

[hsandeep]

Cell Q4 & R4 generates numerical values.
Range K3:P5 also generates numerical values.

In B4 I require the cell’s value from K4:P4 which is equal to Q4 provided Q4>0. Thereafter, in B3 I require the corresponding value from K3:P3 and in B5 I require the corresponding value from K5:P5
Similarly, In C4 I require the cell’s value from K4:P4 which is equal to R4 provided R4>0. Thereafter, in C3 I require the corresponding value from K3:P3 and in C5 I require the corresponding value from K5:P5

How to accomplish?
Thanks in advance

 

[etaf]

i suspect i maybe missunderstanding exactly what after
But my interpretation of the question is this

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3		1200	200								200	400	600	800	1200	1400
4		12	2								2	4	6	8	12	14	12	2
5		120000	20000								20000	40000	60000	80000	120000	140000
6
7
8
Sheet1

Cell Formulas
Range	Formula
B3:C3	B3	=INDEX($K$3:$P$3,MATCH(B4,$K$4:$P$4,0))
B4:C4	B4	=IF(Q4>0,Q4,"")
B5:C5	B5	=INDEX($K$5:$P$5,MATCH(B4,$K$4:$P$4,0))
L5:P5	L5	=L4*10000

Otherwise - it would be better to
Provide

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[hsandeep]

i suspect i maybe missunderstanding exactly what after
But my interpretation of the question is this

etaf You understood correctly & this is what I needed. Thanks for it & your efforts.

 

[etaf]

you are welcome