View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Can somebody help me with this formula

Enter this in a cell

="ck"&ROW()&":"&VLOOKUP($AH$3,$AK$1:$AO$12,5)&ROW( )

and see what you get. Does it relate to a range that you recognise?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Inga" wrote in message
...
Can somebody help me with this formula
It's in a database but I don't now wath to make of it
=SUM(INDIRECT("ck"&ROW()&":"&VLOOKUP($AH$3,$AK$1:$ AO$12,5)&ROW()))