Still Stuck!!

  • Thread starter Thread starter Chubby
  • Start date Start date
C

Chubby

Here is my problem again.

On sheet 'Report' in cell F6 I need to put a formula that
will check the number that is entered into cell H6 and
input into F6 the following:

if H6 = 1 then F6 will equal cell B6 in sheet 'Summary'
if H6 = 2 then F6 will equal cell C6 in sheet 'Summary'
if H6 = 3 then F6 will equal cell D6 in sheet 'Summary'
and so on up to H6 = 31. I have tried setting up a
lookup sheet as suggested and used the following but it
hasn't worked.

IN CELL F6 =INDEX('LOOKUP'!$B$1:$B$10,MATCH(H6,'LOOKUP'!
$A$1:$A$10,1)) I couldn't get this to work. Any new
ideas? Thanks a bunch and then some!!!
 
Try

=INDIRECT("SUMMARY!" &,VLOOKUP(H6,'LOOKUP'!$A$1:$A$10,1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top