问题描述:

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

TIA

网友答案:

If your required price is in say A6, then something like the following might suit:

=INDEX(1:1,MATCH(A6,1:1,0)+1)
相关阅读:
Top