ExcelBanter - Nil in Place Off #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Nil in Place Off #N/A (https://www.excelbanter.com/excel-worksheet-functions/81814-nil-place-off-n.html)

Steved

Nil in Place Off #N/A

Hello from Steve Dee

Is it possible please to have Nil in place off #N/A

=VLOOKUP(A127,'Wellington Total''s'!$A$2:$C$1991,2,FALSE)

Thankyou.

bpeltzer

Nil in Place Off #N/A

Place the vlookup within a test for NA:
=if(isna(VLOOKUP(A127,'Wellington
Total''s'!$A$2:$C$1991,2,FALSE)),"",VLOOKUP(A127,' Wellington
Total''s'!$A$2:$C$1991,2,FALSE))
You could replace "" with any other sort of 'default' you like.

"Steved" wrote:

Hello from Steve Dee

Is it possible please to have Nil in place off #N/A

=VLOOKUP(A127,'Wellington Total''s'!$A$2:$C$1991,2,FALSE)

Thankyou.

Steved

Nil in Place Off #N/A

Excellent and Thankyou for the expanded explanation.

"bpeltzer" wrote:

Place the vlookup within a test for NA:
=if(isna(VLOOKUP(A127,'Wellington
Total''s'!$A$2:$C$1991,2,FALSE)),"",VLOOKUP(A127,' Wellington
Total''s'!$A$2:$C$1991,2,FALSE))
You could replace "" with any other sort of 'default' you like.

"Steved" wrote:

Hello from Steve Dee

Is it possible please to have Nil in place off #N/A

=VLOOKUP(A127,'Wellington Total''s'!$A$2:$C$1991,2,FALSE)

Thankyou.

All times are GMT +1. The time now is 02:30 PM.