ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't use Find function in formula (https://www.excelbanter.com/excel-discussion-misc-queries/95989-cant-use-find-function-formula.html)

Winnie

Can't use Find function in formula
 
Can't use Find function After set a formula "=Sheet1!A1" on Sheet2
e.g. input 123 on the find function, can't show a result

Dav

Can't use Find function in formula
 

Its not entirely clear what you want, or if you are using the find
function (like the sum function) or edit_find. So it is hard to give a
good answer, you need to give more explaination. However if it is the
latter are you on the sheet you are searching for the result on, and is
it serching forumulas in the lookin box and you want values.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=555473



All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com