Thanks guys, that has worked perfectly to pull through the Category. Struggling a bit to get it to work with my Level though. Below is the array I've created. my budget codes are all 2 to 3 digits in the below format
A1
C10
D15
This is how they appear within the BUDGET CODE variable. So the first Category array is working and recognising the letter and assigning the Category. How can i do the same but get it to look at the number and then return from my array below?
Thanks so much
[
{
"Number": 1,
"Level": "RAFT SLAB"
},
{
"Number": 2,
"Level": "B4"
},
{
"Number": 3,
"Level": "B3"
},
{
"Number": 4,
"Level": "B2"
},
{
"Number": 5,
"Level": "B1"
},
{
"Number": 6,
"Level": "GF"
},
{
"Number": 7,
"Level": "UGF"
},
{
"Number": 8,
"Level": "L1"
},
{
"Number": 9,
"Level": "L2"
},
{
"Number": 10,
"Level": "L3"
},
{
"Number": 11,
"Level": "L4"
},
{
"Number": 12,
"Level": "L5"
},
{
"Number": 13,
"Level": "L6"
},
{
"Number": 14,
"Level": "L6M"
},
{
"Number": 15,
"Level": "L7"
},
{
"Number": 16,
"Level": "L8"
},
{
"Number": 17,
"Level": "L9"
},
{
"Number": 18,
"Level": "L10"
},
{
"Number": 19,
"Level": "L11"
},
{
"Number": 20,
"Level": "L12"
},
{
"Number": 21,
"Level": "L13"
},
{
"Number": 22,
"Level": "L14"
},
{
"Number": 23,
"Level": "L15"
},
{
"Number": 24,
"Level": "L16"
},
{
"Number": 25,
"Level": "L17"
},
{
"Number": 26,
"Level": "L18"
},
{
"Number": 27,
"Level": "L19"
},
{
"Number": 28,
"Level": "L20"
},
{
"Number": 29,
"Level": "L21"
},
{
"Number": 30,
"Level": "L22"
},
{
"Number": 31,
"Level": "L23"
},
{
"Number": 32,
"Level": "L24"
},
{
"Number": 33,
"Level": "L25"
},
{
"Number": 34,
"Level": "L26"
},
{
"Number": 35,
"Level": "L27"
},
{
"Number": 36,
"Level": "L28"
},
{
"Number": 37,
"Level": "L29"
},
{
"Number": 38,
"Level": "L30"
},
{
"Number": 39,
"Level": "L32"
},
{
"Number": 40,
"Level": "L33"
},
{
"Number": 41,
"Level": "L34"
},
{
"Number": 42,
"Level": "L35"
},
{
"Number": 43,
"Level": "L36"
},
{
"Number": 44,
"Level": "L37"
},
{
"Number": 45,
"Level": "L38"
},
{
"Number": 46,
"Level": "L39"
},
{
"Number": 47,
"Level": "ROOF"
}
]