Finding a value and returning corresponding info
Hi Vicky,
The following formula assumes.
Your columns start at column A (or column 1) because the column numbers are
returned by the Match function.
Your low number is in column E because that number is used in the Match
function.
Your provider column is column F.
The formula below is in cell F2. (Can copy down)
=INDIRECT("R1" & "C"&MATCH(E2,A2:D2,0),FALSE)
--
Regards,
OssieMac
|