Is it possible to get the adjacent value in column A based on the given cell reference number?

[papajups]

Good day All,


Hope all is well.

May I ask if it is possible to get the adjacent value in column A based on the given cell reference number?

For example:


A25: Dog
A26: Cat


If cell G1 = C25, then return the value ‘Dog’. And if cell G1 = D26, then return the value ‘Cat’.


I would greatly appreciate your help on this matter. Thank you in advance!


regards,

Papajups

 

[Trebor76]

Hi Papajups,

You can use the following formula to return the value in the cell reference entered in cell G1:

=INDIRECT(G1)

HTH

Robert

 

[Aladin Akyurek]

Your cell references are confusing: What is the relation between A25 and C25 on one hand and between A26 and D26 on the other?

 

[papajups]

Your cell references are confusing: What is the relation between A25 and C25 on one hand and between A26 and D26 on the other?

Good day Aladin,


I am sorry if I confused you.

I have attached my sample file for your reference. For example, if G1 = B3, then if possible, I wish to return the value I have in cell A3 instead of B3. In this case, the value to be returned in cell G1 should be 'Ashley Owens'.

Another example is if G1 = C15, then I wish to return the value of cell A15, which is 'Shay Curtis'.

Lastly, if G1 = D10, then the value should be 'Juperth Buban'.


May I ask if this is possible?

Appreciate your response on this matter.


regards,
Papajups

 

[papajups]

Good day Aladin,


I am sorry if I confused you.

I have attached my sample file for your reference. For example, if G1 = B3, then if possible, I wish to return the value I have in cell A3 instead of B3. In this case, the value to be returned in cell G1 should be 'Ashley Owens'.

Another example is if G1 = C15, then I wish to return the value of cell A15, which is 'Shay Curtis'.

Lastly, if G1 = D10, then the value should be 'Juperth Buban'.


May I ask if this is possible?

Appreciate your response on this matter.


regards,
Papajups

Aladin,


Sorry I am unable to attach an image. Please see below for my sample file.

[TABLE="width: 875"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Employee[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Extra Scheduled Break 30 minutes[/TD]
[TD]1 WFH Day/Extra Scheduled Break 30 minutes[/TD]
[TD]1 hour early depart or
1 hour arrive late[/TD]
[/TR]
[TR]
[TD]Ashley Owens[/TD]
[TD]R 110918 V 020719[/TD]
[TD]R 080918 V 110718 U 081518[/TD]
[TD]R 101918 V 011719[/TD]
[/TR]
[TR]
[TD]Charlene Valenova[/TD]
[TD]Expired U[/TD]
[TD]Expired U[/TD]
[TD]R 080918 V 110718 U 110718[/TD]
[/TR]
[TR]
[TD]Cristina Pagan[/TD]
[TD]Expired U[/TD]
[TD]R 092518 V 122418[/TD]
[TD]R 121818 V 031819[/TD]
[/TR]
[TR]
[TD]Dewayman Brown[/TD]
[TD]Expired U[/TD]
[TD]Expired U[/TD]
[TD]Expired U[/TD]
[/TR]
[TR]
[TD]Ferleen Catamora[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]R 080918 V 110718 U 110718[/TD]
[/TR]
[TR]
[TD]Jellie Dela Cruz[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]Jennifer Trent-George[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]R 080918 V 110718 U 110718[/TD]
[/TR]
[TR]
[TD]Juperth Buban[/TD]
[TD]Expired U[/TD]
[TD]U[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]Maebeth Espina[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]Marichelle Apostol[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]Mima Miller[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]Richard Chiu[/TD]
[TD]Expired U[/TD]
[TD]R 080918 V 110718 U 110718[/TD]
[TD]R 101918 V 011719[/TD]
[/TR]
[TR]
[TD]Shay Curtis[/TD]
[TD]U[/TD]
[TD]U[/TD]
[TD]R 092518 V 122418[/TD]
[/TR]
[TR]
[TD]Floriane Estosane[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]