Forum Discussion

Copper Contributor

Jun 20, 2020

Issue with referencing the correct cell In excel within a formula

Im working on a file at work. I have 2 tabs in an excel file. Tab 1 contains an imported XML file. Tab 2 contains some excel formulas that looks at data from Tab 1 to bring into Tab 2. However, whenev...

excel

Formulas and Functions

DevendraJain

Iron Contributor

Jun 21, 2020

Hey I have a solution for the same problem. Please provide the Excel file and I will help you out with this

Angelus_Mortis
Copper Contributor
Jan 05, 2024
Devendra
I know this post is a little old, but I have the same issue as OP. Could you please contact for assistance or post here what the fix is for this issue?
- DevendraJain
  Iron Contributor
  Jan 06, 2024
  Angelus_Mortis You can connect with me on my mail Id or message me personally I will solve the issue
Ozgal07
Copper Contributor
Jun 21, 2020
Thank you, since it a work file on my work machine I won’t be able to provide it.

Will you be able to give me instructions on how I can possibly resolve this?

Thanks again.
- DevendraJain
  Iron Contributor
  Jun 21, 2020
  Send me screenshots
  - Ozgal07
    Copper Contributor
    Jun 21, 2020
    Ok, I will send something over during the week. Thanks again
- DevendraJain
  Iron Contributor
  Jun 21, 2020
  Ok then first create two tables