Hi
I have a vlookup that i need to extend across a large array. I believe the COLUMN formula will allow me to do this without having to manually change the column I'm looking up.
Any help on using this formula would be much appreciated as I'm new to it.
=(VLOOKUP($A9,$A$15:$F$19,2,FALSE)*VLOOKUP(B$8,$J$1:$N$5,2,FALSE))+((VLOOKUP($A9,$A$15:$F$19,3,FALSE)*VLOOKUP(B$8,$J$1:$N$5,3,FALSE))+((VLOOKUP($A9,$A$15:$F$19,4,FALSE)*VLOOKUP(B$8,$J$1:$N$5,4,FALSE))+((VLOOKUP($A9,$A$15:$F$19,5,FALSE)*VLOOKUP(B$8,$J$1:$N$5,5,FALSE)))))
Thanks
Dan (Excel 2007)
I have a vlookup that i need to extend across a large array. I believe the COLUMN formula will allow me to do this without having to manually change the column I'm looking up.
Any help on using this formula would be much appreciated as I'm new to it.
=(VLOOKUP($A9,$A$15:$F$19,2,FALSE)*VLOOKUP(B$8,$J$1:$N$5,2,FALSE))+((VLOOKUP($A9,$A$15:$F$19,3,FALSE)*VLOOKUP(B$8,$J$1:$N$5,3,FALSE))+((VLOOKUP($A9,$A$15:$F$19,4,FALSE)*VLOOKUP(B$8,$J$1:$N$5,4,FALSE))+((VLOOKUP($A9,$A$15:$F$19,5,FALSE)*VLOOKUP(B$8,$J$1:$N$5,5,FALSE)))))
Thanks
Dan (Excel 2007)