View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 3
Default how to determine column heading from lookup

Thanks Tom,

sorry, but that's not what I'm looking for, I should have explained
more clearly.

The table above will go from TariffA to Tariff X, and the same for the
phone models, say around 40

Maybe a macro would be better suited to my needs?

Get the phone model and money in
Search the table for the model
Use the row number to look for the money in
return the column number and use that to find the column title