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

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
Joined
Mar 26, 2007
Messages
9,173
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,173
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!!!
 
Master Excel Bundle

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.

Forum statistics

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