Lookup

G

Guest

I have a spreadsheet that contains the following information:

100 ABC Telecom
150 DEF Gaming
200 GHI Cable
50 XYZ Telecom
How can I write a formula to pull the info into a different worksheet
whenever Telecom appears? So the end result would just be:
100 ABC Telecom
50 XYZ Telecom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup with IF criteria 2
Sum based on criteria in rows and columns 1
Lookup row and columbn using text for both 4
Counting question 5
Lookup and dates 5
lookup duplicate value 7
Formatting Sheet 5
Rearrange sheet data 3

Top