I am currently using this VLOOKUP:
=VLOOKUP(A11:A92,'H:\[file name]Sheet1'!$A$90:$B$92,2,FALSE)
this works perfectly, however, I would like to be able to drag the formula down a large column.
When I do, the cells with data in them return the correct numbers, while the cells without a lookup value return N/A.
Then I have to go through the column and delete the N/A's and change them to zeros.
How can I have it return a 0 if there is no value?
Is it 'if blank' ? How do I work that into my formula?
Can I have it return nothing?
Thank you!
=IF(A11="",0,VLOOKUP(A11,'H:\[file name]Sheet1'!$A$90:$B$92,2,FALSE))
---
Ben Van Johnson
I tried that and it still returned N/A
Maybe you should post a workbook. That lookup table looks strange, it's only 3 rows by 2 columns.
---
Ben Van Johnson
This may work for you
=IF(ISNA(VLOOKUP(A11,'H:\[file name]sheet1!$A$90:$B$92,2,FALSE)=TRUE),"",VLOOKUP(A11,'H:\[file name]sheet1!$A$90:$B$92,2,FALSE))
Last edited by grizzly6969; 01-27-2012 at 10:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks