A
Andy Roberts
I have 2 spreadsheets. the first contains all the purchase orders we issue
as follows:-
JobNo, Supplier, Fee
There maybe (and often is) more than one supplier per JobNo. In the second
spreadsheet is a job form and I want to show all the suppliers (based on the
JobNo) - one on each row. I can manage to show one supplier (the first one
the vlookup I'm using finds) but repeating the vlookup in another cell
simply shows the same supplier.
How can I show each supplier based on JobNo in separate cells (e.g. A1 shows
Supplier1, A2 shows Supplier 2 etc? The common link is the JobNo.
Regards
Andy
Excel 2013
Win 7 Pro
as follows:-
JobNo, Supplier, Fee
There maybe (and often is) more than one supplier per JobNo. In the second
spreadsheet is a job form and I want to show all the suppliers (based on the
JobNo) - one on each row. I can manage to show one supplier (the first one
the vlookup I'm using finds) but repeating the vlookup in another cell
simply shows the same supplier.
How can I show each supplier based on JobNo in separate cells (e.g. A1 shows
Supplier1, A2 shows Supplier 2 etc? The common link is the JobNo.
Regards
Andy
Excel 2013
Win 7 Pro