Tech Support banner

Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
161 Posts
Discussion Starter #1
Hi Guys,

I will do my best at explaining my situation, hopefully it is possible and someone knows how.

We have a Workbook which is used to log Calls done over the Radio for Security guards. Just to have a copy of where they have been at what time.

Now at the moment they have to say their Security Licence over the radio to Identify who they are.

Now I had an idea, if each guard had a pass-phrase sort of thing.

E.G. John Blow = JG467

He states his pass-phrase of the radio and whoever is monitoring enters the Pass-Phrase into the excel.

Once the the Pass-Phrase has been entered, in a cell next to it, it comes up with the guards name assigned with that Phrase.

Would something like this be possible.

I know a database is more suitable, but I wanted to give this idea a try
 

·
Registered
Joined
·
160 Posts
Re: Excel Question

How about using a simple VLOOKUP?

Let's say, for example, you create a lookup table with a column of passphrases in column G and the names in column H, so that range G1:H5 looks something like this:

Code:
   G                H
1  PASSPHRASE       NAME
2  DC453            Ken Gold
3  JG467            John Blow
4  AB952            Rich Bigg
5  BR549            Junior Samples
Now, let's say you want to type the passphrase in cell B2 and have the guard's name appear in cell A2. You might set it up like this:

Code:
   A                B
1  NAME             PASSPHRASE
2                   JG467
To get the guard's name in this example, you would enter a formula like this in cell A2:

Code:
=VLOOKUP(B2,G1:H5,2,FALSE)
Then, when you put JG467 in cell B2, cell A2 would show John Blow. If you put DC453 in cell B2, cell A2 would show Ken Gold.
 

·
Registered
Joined
·
161 Posts
Discussion Starter #4
Re: Excel Question

Thanks Guys for your replies.

David M58, I like the look of your solution

I am playing around with it now.

Once Again thanks for the idea and Formula, greatly appreciated.
 

·
Registered
Joined
·
161 Posts
Discussion Starter #5
Re: Excel Question

Another question.

What would be the best way to incorporate having First and Last names into separate cells

So we have the 3 Columns one for First and another for Last name and then the third for the Passphrase
 

·
Registered
Joined
·
161 Posts
Discussion Starter #6
Re: Excel Question

Never mind figured it out, changing col_index_num fixes it.

All good

Thanks guys
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top