ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   simple find (https://www.excelbanter.com/excel-worksheet-functions/52862-simple-find.html)

tcpteacher

simple find
 

I have a seating chart with a cell I don't see a formula for. I can
enter the seat number (ex. 12345) into the cell (B1) and it will move
to and highlight the corresponding cell within the sheet which enables
me to locate the seat within a room. I need to duplicate this for
another workbook. What is the formula?


--
tcpteacher
------------------------------------------------------------------------
tcpteacher's Profile: http://www.excelforum.com/member.php...o&userid=28434
View this thread: http://www.excelforum.com/showthread...hreadid=480345


tcpteacher

simple find
 

Skip it- I figured it out. Basic conditional formatting. Silly me.


--
tcpteacher
------------------------------------------------------------------------
tcpteacher's Profile: http://www.excelforum.com/member.php...o&userid=28434
View this thread: http://www.excelforum.com/showthread...hreadid=480345


Don Guillett

simple find
 
See how just posting to this group helps

--
Don Guillett
SalesAid Software

"tcpteacher" wrote
in message ...

Skip it- I figured it out. Basic conditional formatting. Silly me.


--
tcpteacher
------------------------------------------------------------------------
tcpteacher's Profile:

http://www.excelforum.com/member.php...o&userid=28434
View this thread: http://www.excelforum.com/showthread...hreadid=480345





All times are GMT +1. The time now is 02:22 AM.

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