Hello
I've used the Following formulas
Value of D7 = "12345678" is in Sheet2
in cell T7 of Sheet2 I've used below Formula
=@CELL("address",INDEX(Sheet_XLS2023!$D$15:$D$179,MATCH($D7&"*",Sheet_XLS2023!$D$15:$D$179,0)))
RESULT: '[Filename.xlsx]Sheet_XLS2023'!$D$51
ie D51 OF Sheet_XLS2023'!
using above formula
Therefore for value "12345678" i got cell address as D51 of Sheet_XLS2023'!
Then in cell U7 of Sheet 2 I type
=RIGHT(T7, LEN(T7)-31) to get as $D$51
Question 1 : How do i remove $ sign and get as D51
Question 2: How can i use Row 51 in different Formulas
For EG I would Like to use =VLOOKUP appropriately
ie to get the value of F51 from Sheet_XLS2023'!
Thanks
RapchikM
I've used the Following formulas
Value of D7 = "12345678" is in Sheet2
in cell T7 of Sheet2 I've used below Formula
=@CELL("address",INDEX(Sheet_XLS2023!$D$15:$D$179,MATCH($D7&"*",Sheet_XLS2023!$D$15:$D$179,0)))
RESULT: '[Filename.xlsx]Sheet_XLS2023'!$D$51
ie D51 OF Sheet_XLS2023'!
using above formula
Therefore for value "12345678" i got cell address as D51 of Sheet_XLS2023'!
Then in cell U7 of Sheet 2 I type
=RIGHT(T7, LEN(T7)-31) to get as $D$51
Question 1 : How do i remove $ sign and get as D51
Question 2: How can i use Row 51 in different Formulas
For EG I would Like to use =VLOOKUP appropriately
ie to get the value of F51 from Sheet_XLS2023'!
Thanks
RapchikM
Last edited: