ExcelBanter - Lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup (https://www.excelbanter.com/excel-discussion-misc-queries/30929-lookup.html)

Matt

Lookup

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

Don Guillett

use datafilterautofilter

--
Don Guillett
SalesAid Software

"Matt" wrote in message
...
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

All times are GMT +1. The time now is 06:30 PM.