How can I create this it formula?

  • Thread starter Thread starter HR157
  • Start date Start date
=C12*INDEX(B:B,MATCH(C12,A:A,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Hi,

Would this solve the problem for you?

Seems to work on my system

=C12*VLOOKUP(C12,A:B,2,FALSE)

Hope that helps
 
Ah now I see!!

Think I can see what you want to happen now!! :)

Try this formula in cell d11

=SUM(D3:D10)*VLOOKUP(SUM(D3:D10),A:B,2,FALSE)

You can still only have a maximum of 9 in your data entry though - if
the sum goes larger than 9 this spreadsheet will not be able to find a
lookup value. To give you a visual indicator that this has happened you
could use thi formula in cell d11 instead

=IF(SUM(D3:D10)>9,"Entry values too
large",SUM(D3:D10)*VLOOKUP(SUM(D3:D10),A:B,2,FALSE))


Hope that solves it for you this time!!
 
Ah now I see!!

Think I can see what you want to happen now!! :)

Try this formula in cell d11

=SUM(D3:D10)*VLOOKUP(SUM(D3:D10),A:B,2,FALSE)

You can still only have a maximum of 9 in your data entry though - if
the sum goes larger than 9 this spreadsheet will not be able to find a
lookup value. To give you a visual indicator that this has happened you
could use thi formula in cell d11 instead

=IF(SUM(D3:D10)>9,"Entry values too
large",SUM(D3:D10)*VLOOKUP(SUM(D3:D10),A:B,2,FALSE))


Hope that solves it for you this time!!
 
Back
Top