#N/A and eliminating it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
....=if(isna(VLOOKUP(A10,Items!A2:C5,3,FALSE)),"",VLOOKUP(A10,Items!A2:C5,3,FALSE))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Null/Blank Rows 8
Vlookup help 2
#N/A 5
Avoiding #N/A 4
Vlookup - N/A 4
VLOOKUP returning #N/A result 2
#N/A problem 6
Help: Using CONCATENATE (and a COUNT?) for a total result 3

Back
Top