In C1 put this formula and copy down........

=IF(B1="","",A1)

or

=IF(ISTEXT(B1),A1,"")

Vaya con Dios,
Chuck, CABGx3




"Bran987" wrote in
message ...

Hi guys!

I need a formula that does this:

OK I'm going to draw a spreadsheet
.....A..........B......
1..100.....dog....
2..150...<blank
3..200......cat.....

so all I want is a formula that looks in Column B and if there is ANY
text at all, returns the value in Column A

So I want it to look into B1 and it will see text there and return
"100", but if it looks in B2 and sees that it is blank, it just won't
return anything.

Can I do this? Seems like it would be a combination of IF and LOOKUP
or something.

Thank you.


--
Bran987
------------------------------------------------------------------------
Bran987's Profile:
http://www.excelforum.com/member.php...fo&userid=7503
View this thread: http://www.excelforum.com/showthread...hreadid=375853