Hi
I use excel 2013
I wrote a formula for a table column (the column name is "date range")
Now, I'm trying to copy it to a different table at a different worksheet (every worksheet represent different country)
and of course I want the formula to use the data at the new table/ spreadsheet
but it doesn't seems to change the references relatively, even though I use "past formula".
I can't use the F4 because it seems like it doesn't influence the table name.
here is the formula like its written in the "New York" spreadsheet:
=IF(AND(A30-[@[Arrival Date]]>0,A30-[@[Arrival Date]]<=2),CONCATENATE(TEXT([@[Arrival Date]],"dd/mm/yy"),"-",TEXT(A30,"dd/mm/yy")),IF([@[Arrival Date]]=A28,B28,[@[Arrival Date]]))
and this is how its appears in the Hamburg spreadsheet:
=IF(AND(A21-NY[@[Arrival Date]]>0,A21-NY[@[Arrival Date]]<=2),CONCATENATE(TEXT(NY[@[Arrival Date]],"dd/mm/yy"),"-",TEXT(A21,"dd/mm/yy")),IF(NY[@[Arrival Date]]=A19,B19,NY[@[Arrival Date]]))
My goal:
At the Hamburg spreadsheet/table, I want the formula to use the Hamburg data
Clarification:
the two table structure and headlines are the same
Thanks a lot
Chen
Bookmarks