View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim desision support Tim desision support is offline
external usenet poster
 
Posts: 1
Default Cell variable in formula

Can I use a cell value as a variable in a formula to bring in a cell content


Cell value Cell Content Desired output
A1=5 B5=house C1=house
A2=10 B10=car C2=car
A3=15 B15=truck C3=truck
A4=20 B20=9 C4=9

I tried as a formula in cell C1 =A(b5) but it didn't work, is
there some formula that I can use if I have 500 rows of data without typing
in the actual formula in cell C1