ExcelBanter - #N/A and eliminating it.

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #N/A and eliminating it. (https://www.excelbanter.com/excel-discussion-misc-queries/140203-n-eliminating.html)

Ted

#N/A and eliminating it.

I created a formula...=VLOOKUP(A10,Items!A2:C5,3,FALSE) to pull Price from
the Items sheet based on a row, in this case A10, (sorry about the
redundancy)! If I clear column A, I get #N/A. I have tried to nest this
formula in an If statement but cannot seem to get it to work. If A column is
blank I want the price to be blank also. Thanks in advance!

Mike

#N/A and eliminating it.

=IF(A1="",0,VLOOKUP(A10,Items!A2:C5,3,FALSE))

"Ted" wrote:

I created a formula...=VLOOKUP(A10,Items!A2:C5,3,FALSE) to pull Price from
the Items sheet based on a row, in this case A10, (sorry about the
redundancy)! If I clear column A, I get #N/A. I have tried to nest this
formula in an If statement but cannot seem to get it to work. If A column is
blank I want the price to be blank also. Thanks in advance!

#N/A and eliminating it.

....=if(isna(VLOOKUP(A10,Items!A2:C5,3,FALSE)),"", VLOOKUP(A10,Items!A2:C5,3,FALSE))

"Ted" wrote:

I created a formula...=VLOOKUP(A10,Items!A2:C5,3,FALSE) to pull Price from
the Items sheet based on a row, in this case A10, (sorry about the
redundancy)! If I clear column A, I get #N/A. I have tried to nest this
formula in an If statement but cannot seem to get it to work. If A column is
blank I want the price to be blank also. Thanks in advance!

All times are GMT +1. The time now is 05:01 PM.