HLookup

[Mark]

I am trying to set up a spreadsheet to help with encryption and ceaser
shifts. I have all the letters in alphabetical order on row 1 and
underneath I have assigned them a value of 0 to 25. In row 3 I have added
a formula which shifts these values up by 3 until 25 where they wrap back to
0. What I want to do now is use Hlookup to assign the letters to each
value they had to start with, for example

A B C D E F.......
0 1 2 3 4 5 6.......
3 4 5 6 7 8 9.......
D E F G H I......

Can this be acheived and what would the formula be?

Regards

Mark

 

[smartin]

I am trying to set up a spreadsheet to help with encryption and ceaser
shifts. I have all the letters in alphabetical order on row 1 and
underneath I have assigned them a value of 0 to 25. In row 3 I have
added a formula which shifts these values up by 3 until 25 where they
wrap back to 0. What I want to do now is use Hlookup to assign the
letters to each value they had to start with, for example

A B C D E F.......
0 1 2 3 4 5 6.......
3 4 5 6 7 8 9.......
D E F G H I......

Can this be acheived and what would the formula be?

Regards

Mark

Yes, but not with HLOOKUP, since it cannot look upward for a result,
only downward or on the search row.

If your first three example rows are in A1:F3, place this in A4 and fill
right:
=INDEX($A$1:$F$1,1,MATCH(A3,$A$2:$F$2,0))