Vlookup help (Excel 2010)

[JFD5863]

Images

attached.

On Sheet two within the Materials and Subcontract Section I require the following:

In the total cost column the Vlookup will recognize what year within the Cost Basis Year Column and match that to the associated multiplier on Sheet one. It will then ,multiple the figure by the multiplier and the number under the Quantity column

For example:


H35 will recognize the year in F25 (2004), look up the multiplier on sheet 1 (1.379479057) and then multiply G25 (£1) by the multiplier and the figure in E35 (10)

So the answer should be 13.79479057

 

[Andrew Poulsom]

Is it?

=G35*VLOOKUP(F35,Sheet1!$B$3:$D$31,3)*E35

 

[Chris Mack]

Are you getting 25s and 35s mixed up? I'm a bit confused.

Here's what I came up with:

=VLOOKUP(F35,Sheet1!B:D,3,FALSE)*G35*E35

Hope this helps,

Chris.

 

[JFD5863]

Thanks, Solved.

Managed to fit in an error function as well and still works