IF question from VLOOKUP result

jim27

New Member
Joined
Sep 29, 2014
Messages
1
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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,109,519
Messages
5,529,315
Members
409,863
Latest member
stacy09
Top