Thread: [Solved] Search the text in 3rd cell by using texts in 2 cells
View Single Post
 
Old 05-09-2014, 09:17 AM
Wries Wries is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Jun 2009
Posts: 40
Wries is on a distinguished road
Default
Hello Shinaj
Not VBA solution, but you can convert your data source field to pivot table and use the GETPIVOTDATA function
i have modified your sheet and attached it.

Kind regards,
Wries
Attached Files
File Type: xlsx Book2.xlsx (16.1 KB, 9 views)
Reply With Quote