I have 2 worksheets , one have taxation rate EUR1 RATE with a list of tariff no in column U is the extract data .
Goal to extract data for column F (sheet breakdown)as criteria column A& D from EUR1 RATE column X1.
I have 2 worksheets , one have taxation rate EUR1 RATE with a list of tariff no in column U is the extract data .
Goal to extract data for column F (sheet breakdown)as criteria column A& D from EUR1 RATE column X1.
hi there. maybe this in cell F2:
=IF(COUNTIF('EUR1 RATE'!F:F,A2),'EUR1 RATE'!$X$1,"")
you can also add an IF formula in G2:
=IF(F2<>"",INDEX('EUR1 RATE'!$U$2:$U$187,MATCH($A2,'EUR1 RATE'!$G$2:$G$187,0)),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks