Return specific value from straight table

[NewToQV]

I have a straight table where I have 4 dimensions and multiple expressions just showing the value of a cell from a staged excel file.

I need to return specific values through out the straight table. The table has been frozen so it cannot be sorted etc.

Example table below. My 4 dimensions are as of date, partner, partner product, min.max.

I need to be able to pull specific Need values in the columns.

Example: I need to pull the a.2 min needed value 1 and display it in a text object

Then in another text object I need to display the A.2. max value in a text object.

So on and so forth. 

Thank you ahead of time!

As Of Date	Partner	Partner Product	Min/Max	Needed values 1	Needed values 2	Needed values 3	Needed values 4
1/1/2018	A	A.1	Min	test 1	value 1	needed 1	last 1
1/1/2018	A	A.1	Max	test 2	value 2	needed 2	last 2
1/1/2018	A	A.2	Min	test 3	value 3	needed 3	last 3
1/1/2018	A	A.2	Max	test 4	value 4	needed 4	last 4
1/15/2018	B	B.1	Min	test 5	value 5	needed 5	last 5
1/15/2018	B	B.2	Max	test 6	value 6	needed 6	last 6
1/15/2018	C	C.1	Min	test 7	value 7	needed 7	last 7
1/15/2018	C	C.2	Max	test 8	value 8	needed 8	last 8

[NewToQV]

I changed the date format in my excel file to match yours 'd-m-yyyy' and uploaded it into QV. I am still receiving a hyphen for my result. 

[Shubham_Deshmukh]

It's really strange. Doesn't make sense but change date format as per your system's date format.

[NewToQV]

I changed it back to match my systems date format and it still receive a hyphen. Looks like I'll just stage and track date changes to another tab 😞 If you can think of anything else please let me know. Thank you for your assistance!

[Shubham_Deshmukh]

Sure...