I think I need a vlookup formula for what I want to do but I am not sure how to word it.
I want excel to return the supplier name to the right of the relevant price, so I want to look up the prices in column A using the range C:J and return the supplier to the right of the corresponding value. See below:
A B C D E F G H I J
R 65.80 R 53.52 Bi-Rite R 7.40 Makro R 12.25 Usavesa R 32.88 Silverlake
If your required price is in say A6, then something like the following might suit: