How can I create this it formula.


+-------------------------------------------------------------------+
|Filename: FORMULA.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4763 |
+-------------------------------------------------------------------+

--
HR157
------------------------------------------------------------------------
HR157's Profile: http://www.excelforum.com/member.php...o&userid=34458
View this thread: http://www.excelforum.com/showthread...hreadid=542176

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"HR157" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> How can I create this it formula.
>
>
> +-------------------------------------------------------------------+
> |Filename: FORMULA.doc |
> |Download: http://www.excelforum.com/attachment.php?postid=4763 |
> +-------------------------------------------------------------------+
>
> --
> HR157
> ------------------------------------------------------------------------
> HR157's Profile:
http://www.excelforum.com/member.php...o&userid=34458
> View this thread: http://www.excelforum.com/showthread...hreadid=542176
>

Please see attachment


+-------------------------------------------------------------------+
|Filename: Beginner-1.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4766 |
+-------------------------------------------------------------------+

--
HR157
------------------------------------------------------------------------
HR157's Profile: http://www.excelforum.com/member.php...o&userid=34458
View this thread: http://www.excelforum.com/showthread...hreadid=542176

Hi,

Would this solve the problem for you?

Seems to work on my system

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

Hope that helps


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=542176

As I mentions before, I am an beginner and honestly I don't get that
this work correctly.




+-------------------------------------------------------------------+
|Filename: beginner.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4768 |
+-------------------------------------------------------------------+

--
HR157
------------------------------------------------------------------------
HR157's Profile: http://www.excelforum.com/member.php...o&userid=34458
View this thread: http://www.excelforum.com/showthread...hreadid=542176

Ah now I see!!

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

Try this formula in cell d11

=SUM(D310)*VLOOKUP(SUM(D310),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(D310)>9,"Entry values too
large",SUM(D310)*VLOOKUP(SUM(D310),A:B,2,FALSE))


Hope that solves it for you this time!!


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=542176

Ah now I see!!

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

Try this formula in cell d11

=SUM(D310)*VLOOKUP(SUM(D310),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(D310)>9,"Entry values too
large",SUM(D310)*VLOOKUP(SUM(D310),A:B,2,FALSE))


Hope that solves it for you this time!!


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=542176