View Single Post
  #1  
Old 5th May 2018, 12:13 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default 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:
76 35 75 36 Class 4 37 74 38 73 39 72 40 Class 3 41 71 42 70 43


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
_______________________________________________
Reply With Quote