pull data from one row if another row contains certain text

C

coasterdude

Can someone please get me started on this? I have spreadsheet that I want to
pull text in one row of another row contains "Example".

A B C
1 45 Example
2 34 Blablabla
3 56 Example

Would return
45
56
 
C

coasterdude

Thanks. But I would I output this to another spreadsheet? I put this formula
in another cell and it only returns the first number (45). On another note,
autofilter will not work because I am looking for a string in row C, so I
will be searching for "*Example*"
--
Kevin


John said:
HI
Try this =IF(C1="Example",A1,"")
HTH
John
 
J

John

Hi
The formula =IF(C1="Example",A1,"") is base on your sample.
It's made to be drag down as far as needed.
To do that, move your cursor to the buttom right side of the cell, you will
see your cursor change to a dark cross, click your left mouse button and
drag down. The result should be the same as your example.
Now you say :> But I would I output this to another spreadsheet? !!!
If you like the result on another sheet this maybe what you would like
=IF(Sheet1!C1="Example",Sheet1!A1,"").
This formula is referencing >Sheet1 and you would type this in another
sheet.
HTH
John

coasterdude said:
Thanks. But I would I output this to another spreadsheet? I put this
formula
in another cell and it only returns the first number (45). On another
note,
autofilter will not work because I am looking for a string in row C, so I
will be searching for "*Example*"
 

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

Top