Hlookup or index help

**sav1979** · 04-09-2017, 01:12 AM

Hi all,

I need some simple help (I believe) which I am struggling on. For some reason I cannot attach the file. On the first tab I have a list of names in the first column. I need to somehow pick up the supplier name from the second tab so it populates from left to right. In column B2, I have a user name, in column C,D,E,F,G I want to have a supplier name associated to that user, up to 5 suppliers. C1 is Supplier 1, C2 is suppler 2 etc.
In the next tab I have a list of user names in column C and then an associated supplier name in column D. I basically need to link the first list of user names with the list of associated supplier names in a horizontal format.

So it would look like User Name – Supplier A – Supplier D – Supplier C etc

Hopefully this makes sense but unless the website allows me to upload a file it is difficult to explain

**FDibbins** · 04-09-2017, 01:19 AM

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**AliGW** · 04-09-2017, 03:50 AM

Please do not create duplicate threads on the same issue. You may continue here: https://www.excelforum.com/excel-gen...-or-index.html

Thread closed.