help

  LivEviL 16:43 06 Oct 07
Locked

hi i work for an alarm company and we have such things as remote reset codes for alarm
one particular alarm system has reset codes which doesnt have a algorithm we just have a sheet with say

1 = 1234568
2= 8654321

and so on i have 100 of these damn codes
i want to make life easier to find the correct code and reset code by making a dos programm of sum sort

so say if i entered in a box 1 it would then display
1234568 and so on does anyone know how to right this i can imagine the programmin being somthing like

if 1 is entered then display 1234568
if 2 is entered the dislplay 8654321

can anyone help me with the script or what i have to write sorry if this is the wrong place to write this , if so can you give me links to correct places

  VoG II 16:48 06 Oct 07

If you have Excel, just make your list of numbers in column A and reset codes in column B.

In say D1 enter the number to lookup and in E1 the formula

=VLOOKUP(D1,A$1:B$100,2,FALSE)

which will return the reset code or #N/A if the number isn't found.

  LivEviL 17:19 06 Oct 07

thats ok but i hope to send this to the monitoring center aswell who will use i for customer calls ect any ideas on how to make it as an .exe programm?

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced