Good day
Please can I get help with the following query:
In my workbook, On sheet1, from Column E ( Row 2) . . .
In Column E, I have Reference Numbers ( e.g DCB01 ) - About 500 Lines
In Column F:AF, (Row 1) - I have Supplier Names
In Column F : AF (Rows 2:500) - I have Prices.
On sheet 2, in Column A, I am entering the reference Number, and in Column B, I would like to see the Name of the Supplier with the lowest price from Sheet 1 - for the reference number
I have been trying combinations of Vlookup, Index and Match - But I just cannot get it to work
Please help
Thanks
JVN
Please can I get help with the following query:
In my workbook, On sheet1, from Column E ( Row 2) . . .
In Column E, I have Reference Numbers ( e.g DCB01 ) - About 500 Lines
In Column F:AF, (Row 1) - I have Supplier Names
In Column F : AF (Rows 2:500) - I have Prices.
On sheet 2, in Column A, I am entering the reference Number, and in Column B, I would like to see the Name of the Supplier with the lowest price from Sheet 1 - for the reference number
I have been trying combinations of Vlookup, Index and Match - But I just cannot get it to work
Please help
Thanks
JVN