Forum Discussion
EXCEL QUESTION
Hi fmdon ,
thank you for further details my suggestion is shown in the attached sample file.
Is the suggestion in the attached sample file similar to what you are looking for? Both formulas must be entered as arrayformulas with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
Do you see any way of lookup into those 3 different tabs and updating/ bringing to this 4th one (that is my boxes list) always tying up the lookup and the bringing the results always considering the last movement and date ?
Thanks for your time and attention!
Attached is my sample file which returns the location of the boxes along with their most recent dates of arrival and departure. However i wonder what the content of the 3rd table is. I understand that there is a 1st table for the dates of arrival and a 2nd table for the dates of departure. Perhaps you can give an example of the data of the 3rd table.
- hello Oliver, sorry, I was not clear with my example… actually in all the 3tabs we have the most recent date of arrival, most recent date of departure and location., the difference is that 1st tab is for imp, the 2nd for exp and the 3rd for empties boxes. The goal is to bring in a 4th tab the informations for each box that are spread along all the 3tabs.
This 4th tab will have as the main goal, to show the last position of the box…Hi fmdon ,
thank you for further details my suggestion is shown in the attached sample file.