Nested Lookup function in excel, Urgent!

Question

Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the Category in cell D5, and returns the results based on the data in the range A8:F32.<br><br><br><br><br><br>^I have been trying like **** to make this work and I cant figure it out. D5 refers to a cell containing a data validation list containing three categories. The idea is that a transaction ID will be entered into cell B5 and a data criteria will be selected<br> from the list in D5 and in F5 (Where this function needs to be) the corresponding results will be displayed from the array table.<br><br><br>

Answer 1

I figured it out in case anyone is interested:

Answer 2

Hi Carmine,

Thanks for your sharing. It will definitely benefit others who come across this thread.

If you have any other questions, feel free to post a new thread in our forum.

Regards,

Tina