Hard for me to explain.

If i enter the word cash in A1, the amount of cash in B1 eg £100.00, i
also want the same amount of cash listed in F1, how do i do a formula
to recognize that when the word cash is displayed in a column, i want
F1 to copy the cell of B1 which is the amount of cash.

Please help anyone


--
JILLY
------------------------------------------------------------------------
JILLY's Profile: http://www.excelforum.com/member.php...o&userid=33008
View this thread: http://www.excelforum.com/showthread...hreadid=528859