How can I create this it formula?

B

Bob Phillips

=C12*INDEX(B:B,MATCH(C12,A:A,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
M

mr_teacher

Hi,

Would this solve the problem for you?

Seems to work on my system

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

Hope that helps
 
M

mr_teacher

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!!
 
M

mr_teacher

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I create this conditional formatting formula? 1
How I make this formula 1
what I do wrong? 3
I need help with a conditional formula 3
Conditional Formula? 1
How can I create this formula? 3
Networkdays 16
Need Formula To Identify Lowest Price in Column 2

Top