hi all,
please help me on below.
I have data of travel agency. I want to know Company Name & Charges From Place 1 to Place 2 when I enter the names of both places.
thanks
hi all,
please help me on below.
I have data of travel agency. I want to know Company Name & Charges From Place 1 to Place 2 when I enter the names of both places.
thanks
Hi,
Welcome to excelforum.
Can you please put what is your expected result?
Thanks
Ankur
for example I want to go RESEARCH CENTER from CITY 4
(manually DB search)
minimum Charges are $ 325 offered by TA4
max charges are $ 525 offered by TA3.
Hi,
See the attached file. I have used the following array formula. These need to be confirmed by pressing CTRL+SHIFT+ENTER
In C22:
=MIN(INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),3):INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),7))
In D22:
=IFERROR(INDEX($A$1:$G41,1,SMALL(IF(INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),3):INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),7)=$C$22,COLUMN($C$1:$G$1)),COLUMN(A1))),"")
drag this to the right
In C25:
=MAX(INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),3):INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),7))
In D25:
=IFERROR(INDEX($A$1:$G44,1,SMALL(IF(INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),3):INDEX($A$1:$G$17,MATCH(1,($A$1:$A$17=$A$22)*($B$1:$B$17=$B$22),0),7)=$C$25,COLUMN($C$1:$G$1)),COLUMN(A1))),"")
drag this to the right.
Last edited by cbatrody; 08-19-2015 at 03:52 AM.
Thank you
You are welcome
If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.
Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks