PDA

View Full Version : Solved: Non-VBA help - VLookup type thing



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

Krishna Kumar
10-31-2008, 04:23 AM
Hi,

Try,

=INDEX('Cost Details'!C110: D113,MATCH(E4,'Cost Details'!B110:B113,0),MATCH(E6,'Cost Details'!C109: D109,0))

HTH

anthony20069
10-31-2008, 04:27 AM
Hi,

Thanks for that, but when i insert that code into the cell - it brings up a dialog box for me to select a worksheet (dialog box is called "Update Values: Cost Details")

Any thoughtS?

Krishna Kumar
10-31-2008, 04:31 AM
Do you have a sheet called Cost Details?

anthony20069
10-31-2008, 04:34 AM
The sheet is called Cost Deatil with no S, I have changed it and in the cell it now has the value of #N/A

Krishna Kumar
10-31-2008, 04:42 AM
Hi,

See attached.

anthony20069
10-31-2008, 04:44 AM
It is saying the Doc is corrput and can not be opened...

Krishna Kumar
10-31-2008, 04:46 AM
Download now.

anthony20069
10-31-2008, 04:56 AM
This is weird, when i copy and past your code, it still provides me with #N/A???? - have checked the cell values and they are correct....

Aussiebear
10-31-2008, 04:58 AM
Please make sure that any workbooks that are being made available for downloads are active, accurate and accessible. otherwise all the help we kindly offer is wasted.

anthony20069
10-31-2008, 05:03 AM
Please make sure that any workbooks that are being made available for downloads are active, accurate and accessible. otherwise all the help we kindly offer is wasted.

File is working now....

I am guess the reason for the #N/A is that the values it is trying to look for - its not finding....

**************

Right, just be being VERY VERY silly, did not match the values :).

Thanks VERY VERY VERY much for your help....

Krishna Kumar
10-31-2008, 05:28 AM
Thanks VERY VERY VERY much for your help....

You are welcome!!

:beerchug: