I need help figuring out this pattern

Question

I have two 2digit hexidemical numbers. Each set of 2 numbers references a certain Item. There are 64 different Items. I'm looking for a way to be able to pick any combination of the two hex numbers and know what the item is without trial and error. Below are some of the number that I found through trial and error.

 

 

 

 

 

00 00 is Item 1

00 01 is Item 2

00 03 is Item 3

..

00 3F Item 64

00 40 Item 1

00 41 Item 2

00 42 Item 3

 

It just doesn't repeat though. The two hex numbers flipped are the same items.

 

42 00 Item 3

41 00 Item 2

 

I randomly came across these that are in reverse order. Not sure if that just happens, so the pattern reveres itself along the way?

4F 4B Item 5
4F 4C Item 4
4F 4D Item 3
4F 4E Item 2
4F 4F Item 1

 

other examples:

01 00 Item 2
01 01 Item 1
01 02 Item 4
01 10 Item 17
04 00 Item 5
10 00 Item 16
10 01 Item 17
14 14 Item1
14 15 Item 2
37 36 Item 2
41 41 Item 1

 

 

I need to figure out a way to take any 4 digit hex number and know which item it is. I can't figure it out.

Answer 1

Perhaps using the MOD function.

 

Convert your number to decimal, divide by 64 and take the remainder.

 

 You will get an integer between 0..63

 

EX.

 

  5D  A3     = 5*16^3 + 13*16^2 + 10*16 + 3 = 23971

 

 23971 / 64 = 374 r 35

 

so Item 35