=IFerror(VLOOKUP(E3,_20181219_milly_final_2!$B$2:$H$175466,7,0),iferror(VLOOKUP(J3,_20181219_milly_final_2!$G$2:$H$175466,2,0)))
Here is a formula that is not working --- I have 2 tabs and each tab contains account # and element #. I am trying to match acct # from tab 1 to acct #on tab 2 and same with the element #. Once these both match, I want to get the fee that is a result of the double match. Each tab has approx. 60,000 rows of data. I put together 2 separate vlookups, but am not sure how to tie them together and add a "THEN" statement.
Any ideas or solutions would be greatly appreciated!
Thank you!!
Here is a formula that is not working --- I have 2 tabs and each tab contains account # and element #. I am trying to match acct # from tab 1 to acct #on tab 2 and same with the element #. Once these both match, I want to get the fee that is a result of the double match. Each tab has approx. 60,000 rows of data. I put together 2 separate vlookups, but am not sure how to tie them together and add a "THEN" statement.
Any ideas or solutions would be greatly appreciated!
Thank you!!