anthony20069
10-31-2008, 04:06 AM
Hi guys,
need your excellent help please. This is a non-VBA question:
Sheet - Cost Details
108 B C D
109 1 2
110 100 24000 18000 (LiveCall:2400018000)
111 150 34000 26000 (LiveCall:3400026000)
112 200 42000 36000 (LiveCall:4200036000)
123 250 58000 45500 (LiveCall:5800045500)
Hope that "table" (now the hard part :) )
On a different sheet (we will call this one "Main")
Is in Row 5 collumn E:L + Row 6 column E:L - If I type 100 in E4 and 2 in E6 (somehow??) in E7 the value off 18000 should appear - same goes with any value on sheet "Cost Details" row B 110:123
Tried with a vlookup but couldnt get it to work :(
Any help would seriosly be greatfull
Thanks inadvance....
Any help is much appreciated
Thanks
need your excellent help please. This is a non-VBA question:
Sheet - Cost Details
108 B C D
109 1 2
110 100 24000 18000 (LiveCall:2400018000)
111 150 34000 26000 (LiveCall:3400026000)
112 200 42000 36000 (LiveCall:4200036000)
123 250 58000 45500 (LiveCall:5800045500)
Hope that "table" (now the hard part :) )
On a different sheet (we will call this one "Main")
Is in Row 5 collumn E:L + Row 6 column E:L - If I type 100 in E4 and 2 in E6 (somehow??) in E7 the value off 18000 should appear - same goes with any value on sheet "Cost Details" row B 110:123
Tried with a vlookup but couldnt get it to work :(
Any help would seriosly be greatfull
Thanks inadvance....
Any help is much appreciated
Thanks