Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default HLookup

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hlookup mtitanium Excel Worksheet Functions 2 July 28th 08 01:48 PM
Hlookup Duplatt New Users to Excel 11 November 9th 07 03:05 PM
HLOOKUP GaryLager Excel Discussion (Misc queries) 0 April 26th 07 03:42 PM
hlookup #N/A stacyjhaskins Excel Worksheet Functions 2 June 27th 05 09:31 PM
HLOOKUP Brad Excel Worksheet Functions 1 June 14th 05 11:39 PM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"