VlookUp

[pjandshelly]

I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would also rank the values with ties.

For example:

A B C
Test No 1
Stop Yes 0
Now No 5

Dashboard returns
Value Total
Now 5
Test 1

 

[Fluff]

Firstly I would strongly recommend getting rid of the merged cells, they will only cause you grief & heartache.

Try
=IFERROR(INDEX($AM$52:$AM$164,MATCH(AA21,$I$52:$I$164,0)),"").

 

[pjandshelly]

That worked. Thank you for all your help.

 

[Fluff]

Glad to help & thanks for the feedback