vlookup help

[JakeMann]

Hello,

This should be simple but I'm have one of those days!

On the attached sheet I need the Vlookup to display all the suppliers from the 'purchase orders' page from the description in B1 on the vlookup page. But it's only displaying the first supplier.

Any idea?

[Pete_UK]

You need to set up a unique reference for each entry in your table, as VLOOKUP (and MATCH) will only find the first matching row. To do this, I have inserted a new column A in the Orders sheet and put this formula in A2:

Please Login or Register  to view this content.

This is then copied down beyond your data, in order to accommodate more orders to be added - I've copied to row 500 (the hyphens help to indicate how far you have copied it), but you could make it more if you wish. You can hide columns A and B if you wish.

Then in the Vlookup sheet I have changed your formula in A2 to this:

Please Login or Register  to view this content.

and copied this down to ensure all possible returns are made (I've done it to row 20, and again the hyphens indicate, though you could leave them out here).

Hope this helps.

Pete