Hi,
Sheet one I want to use the information added into cell a1 (location) to lookup up in sheet 2 everything related to that location (will be orders for the same job, but multiple entries as job needs completing every week (potential 4 orders all different for the same location only differing by date).
on sheet 1 I want for each location to output every order and date.
Im getting lost in IF and VLOOKUPS, feel i might need something a tad more complex or im being completely daft and this is really easy.
HELP Please
Sheet one I want to use the information added into cell a1 (location) to lookup up in sheet 2 everything related to that location (will be orders for the same job, but multiple entries as job needs completing every week (potential 4 orders all different for the same location only differing by date).
on sheet 1 I want for each location to output every order and date.
Im getting lost in IF and VLOOKUPS, feel i might need something a tad more complex or im being completely daft and this is really easy.
HELP Please