pull data from one row if another row contains certain text

  • Thread starter Thread starter coasterdude
  • Start date Start date
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
 
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
Click to expand...
 
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*"
Click to expand...
 
Back
Top