View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RJJ RJJ is offline
external usenet poster
 
Posts: 26
Default How to: If G12=A2 then C2...or if G12=A3 then C3 and so on 30 time

How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30 times.