View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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