# Help with = formula

#### GoKu

##### Board Regular
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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### Gerald Higgins

##### Well-known Member
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
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
Thanx Higgi!!!!
Code:
``=lookup(6,E3:E5,C3:C5)``
is working perfectly!!!

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,649
Messages
5,832,879
Members
430,175
Latest member
Sheenamarie

### 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.

### Which adblocker are you using?

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

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