Cell Referencing with auto populating another cell???

[LYCAN]

Newbie here so please be kind. lol

So what I have; a lot number(1234) entered into H1, a station ID#(A,B,C or D) in H2 and the current date and time in H3.

What I am trying to do is reference the lot number and station ID# then enter the current date into that intersected cell.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]

[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]LOT NUMBER[/TD]
[TD]ST 1[/TD]
[TD]ST 2[/TD]
[TD]ST 3[/TD]
[TD][/TD]
[TD][/TD]
[TD]LOTNUMBER
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1234[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STATION ID[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5678[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9999[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So If I were to enter 5678 into H1 and ST 2 into H2 and the current date into H3. Then C3 would have the date populated into it. Is this something that is doable? Thank you for any and all help.

 

[Special-K99]

Not with a formula.

The formula would have to be in all the cells B2:D3.
As soon as you change the values in H1:H3 the cell in B2:D3 that worked would then show an incorrect value.

I suggest VBA as the proper way to do this btu I'm no expert on VBA.

 

[LYCAN]

Thank you Special-99,

The more I read the more I see where VBA would be the way to go. Maybe a user form????

 

[MickG]

Perhaps something like this:-
https://app.box.com/s/bwmopc0z0sgnmmpyjyyix5v1505x9ss1

 

[LYCAN]

Perhaps something like this:-
https://app.box.com/s/bwmopc0z0sgnmmpyjyyix5v1505x9ss1

Thank you but nothing comes up when I click or paste the link.

 

[MickG]

Not sure what's happening, I've just downloaded it from you "Quote" link.
When you click that link you should be taken to "Box" opening page showing the sheet content , from that you need to click "Download" (top right) and save the file where you like .

If you still can't download it, let me know and I'll send the code for the Userform.

 

[LYCAN]

I was able to download and I believe this is going to work nicely. I believe I could not see the box due to me being on a Mac. Once I was on a PC, no issues.
Thank you very much for this. The more I use it the more I like the results.

 

[MickG]

You're welcome
Glad you have it working