Formul ? #Value

[zone709]

HI,

So this works

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")​

If I add this

+('Pay (2)'!AH2) Then in returns #Value . I just need to add that cell on another sheet​

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")+('Pay (2)'!AH2)


I also tried something like this, but couldn't get it so I don't get any errors on return.

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")+

IFERROR(VLOOKUP($H$3:$H$300,

'Pay (2)'!

$B$2:$Z$288,33,0"")

But get error any suggestions?​

​

​

​

​

​

 

[dfsobral]

are you sure that works?

vlookup lookup value is a single cell not a range. you should have H3 not H3:H300

maybe iserror is hidding an error in your formula

 

[Excel Planet]

HI,

So this works

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")​

If I add this

+('Pay (2)'!AH2) Then in returns #Value . I just need to add that cell on another sheet​

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")+('Pay (2)'!AH2)


I also tried something like this, but couldn't get it so I don't get any errors on return.

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")+

IFERROR(VLOOKUP($H$3:$H$300,

'Pay (2)'!

$B$2:$Z$288,33,0"")

But get error any suggestions?​

​

​

​

​

​

Try

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0)+('Pay (2)'!AH2),"")

 

[zone709]

Orignal


=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")



New one
Returnd Value trying to add column number ,31 Matching H and D id number

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"")+IFERROR(VLOOKUP($H$3:$H$300, 'Pay (2)'!$D$2:$AJ$288,31,0),"")​

 

[zone709]

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"") This works

How do I add this to the one above without getting error? #value

+IFERROR(VLOOKUP($H$3:$H$300, 'Pay (2)'!$D$2:$AJ$288,31,0),"")​

<strike></strike>
​

 

[Excel Planet]

=IFERROR(VLOOKUP($H$3:$H$300, Formulas!$B$2:$Z$288,18,0),"") This works

How do I add this to the one above without getting error? #value

+IFERROR(VLOOKUP($H$3:$H$300, 'Pay (2)'!$D$2:$AJ$288,31,0),"")​

<strike></strike>
​

You need to lookup one value only, not a range of cells.