Search the text in 3rd cell by using texts in 2 cells

Shinaj · #1 05-08-2014, 03:30 PM

I have put my question in the attached file with example. Please help.

Wries · #2 05-09-2014, 09:17 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search cell text from Excel into ms-word	ShailShin	Word VBA	1	04-21-2014 02:12 AM
Unable to vertically center align texts in table cells?	tinfanide	Word	3	11-24-2013 06:37 AM
How to combine different cells data in one cell?	Learner7	Excel	1	07-28-2010 12:07 PM
search a list while typing in a cell	virsojour	Excel	1	07-08-2010 03:10 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM