vlookup question ?

[coltheplumb]

Hi all yup it's me again
ok what i am after this time .... i have this...
=VLOOKUP(DU8,$DT$3:$DU$5,2)+VLOOKUP(DW8,$DT$3:$DU$5,2)

now i want to add this to it somehow ?
=VLOOKUP($DN$4:$DO$6,2)

so what i'm trying to do is in just cell C1 get the information from DU8 and DW8, and get the result to appear in cell C1. any ideas
thanks for any help
Colin X

 

[Arcticwarrio]

your missing what to lookup up here xxxx

=VLOOKUP(xxxx,$DN$4:$DO$6,2)

 

[coltheplumb]

Hi Again
yes i know i have left out a lookup cell, i want the lookup cell to be the one that the formula is in so the formula is in cell C1 but i want the answer/result to be in C1 also. i have tried all different ways to achieve this but to no avail

All this in cell C1
=VLOOKUP(DU8,$DT$3:$DU$5,2)+VLOOKUP(DW8,$DT$3:$DU$5,2),=VLOOKUP(C1,$DN$4:$DO$6,2)... so i want all of this in cell C1.

all help much appriciated

Colin X

 

[Arcticwarrio]

you could try

=VLOOKUP(VLOOKUP(DU8,$DT$3:$DU$5,2)+VLOOKUP(DW8,$DT$3:$DU$5,2),$DN$4:$DO$6,2)

 

[coltheplumb]

Well done Arcticwarrio works perfect
Thanks very much for your help once again
Colin X

 

[coltheplumb]

ok im back again
is there anyway i can stop the #N/A showing in the cell that the formula is in ? i know it clears itself once the information has been entered into the relative cells but just thought it would look better without it.
Cheers
Colin X

 

[Jude24]

Hello Coltheplumb,

Use the iferror combination like;

=IFERROR(VLOOKUP(A2,'Coll B'!A:A,1,0),"")

 

[coltheplumb]

Hi Jude24 .

That sort off stuff is way over my head , i would have no idea where i sould put that on my worksheet???
i did copy it from here and paste it in a small corner, and my documents opened up for me to name it gulp!!

Thanks for your help anyway

Colin X

 

[Jude24]

I want to believe this formula posted by Arcticwarrio worked for you (4)

I have just adjusted it:

=iferror(VLOOKUP(VLOOKUP(DU8,$DT$3:$DU$5,2)+VLOOKUP(DW8,$DT$3:$DU$5,2),$DN$4:$DO$6,2),0)

This formula will return 0 instead of error message. You could further twik it to return nothing... that is by changing the last 0) to "")

Let me know if it helps.

Regards

 

[coltheplumb]

I just love you people XXXXXX Thank you ever so much Jude24, i tried it first with a ,0) but that only changed the #N/A to #NAME, but when i tried the ,"") well i could have wet myself .

Thanks again

Colin XXX