Help with = formula

GoKu

Board Regular
Joined
Dec 18, 2007
Messages
244
Excel Workbook
ABCDEFGHIJKLM
2GOLDFIELDS FREE STATE REGION*APPOINTMENT
3*No.Chair Lift Operator6***
4100Bank/Station Bell Att***On this date2-Jun-08the following candidate
5Snr Incline G/L:***ACossaof section3E
6SurnameCossaA*was tested, evaluated and found competent to
7#3*3E*operate as a:Chair lift operator
8MINE * *:BEATRIX ********
9Date TestedRenewel Date:*I,*the supervisor hereby
10*******appoint the above mentioned to operate as a
11Pf. No.2-Jun-0826-Aug-09*Chair lift operatorin my section.
12M0012573Signature of**Supervisor Sign:*
13Engineer:*
Ticket


Hi All. Posted is my license I am using to license some of my employees. In K7 I have to manually do = to what ever are indicated by the hourglass icon in C3 t0 C5. What formula can I use in K7 to automatically = to the text indicated by the hourglass icon next to it?
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Is the hourglass symbol a text character ?

In which case maybe a LOOKUP, like this
Code:
=lookup(6,E3:E5,C3:C5)
This assumes that the hourglass character is the digit 6 in Wingdings font.
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Also, my solution only seems to work if there is ONLY ONE instance of the hourglass in the target area. If there are two or more, it seems to refer to the last one. Don't know if this is a problem for you - maybe not.
 

GoKu

Board Regular
Joined
Dec 18, 2007
Messages
244
Thanx Higgi!!!!
Code:
=lookup(6,E3:E5,C3:C5)
is working perfectly!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,130,169
Messages
5,640,547
Members
417,151
Latest member
ChickenTenderer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top