|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Excel Help Needed
I have run in to a bit of an issue, wanting to see if i can get help here first, i have a list of race classes and beside that i have a number that i have assigned to represent the class, here is a sample.
Code:
I can then use this =IF(ISNUMBER(SEARCH(AW66,RacePage!$M$6)),AX66,"") formula for todays class of race. This formula extends the length of my class list. AW66 represents the race class AX66 represents the number value RacePage!$M$6 represents today's race class and could be displayed like this on my sheet TAPETA : BM 64 HANDICAP Now this works fine as it is searching for any part of today's race class in my list and returns the value i have assigned that class. The problem i have is i want to swap this around, i need to be able to take a value displayed like this BM72 and search my list to find it's race class value.
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ Last edited by Shaun : 5th May 2018 at 12:15 PM. |
Thread Tools | Search this Thread |
Display Modes | |
|
|