If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to switch a #N/A value into 0
I used the vlookup function to get pricing from a=20
database which is multiplied by a specific volume. When I=20 have no pricing in the database for a product code it=20 returns this #N/A. In the multiplied cells I get the same=20 result and the sum of the result come again this #N/A. I have tried the if function but can't seem to turn=20 around to bring it to a zero value so I can still add the=20 result for product codes I have pricing. Help, Thanks in advance=20 Andr=E9 |
#2
|
|||
|
|||
how to switch a #N/A value into 0
one way:
Assume the lookup value is in A1, and the lookup table is J1:K100: =IF(ISNA(MATCH(A1,J1:J100,0)),0,VLOOKUP(A1,J1:K100 ,2,0)) In article , wrote: I used the vlookup function to get pricing from a database which is multiplied by a specific volume. When I have no pricing in the database for a product code it returns this #N/A. In the multiplied cells I get the same result and the sum of the result come again this #N/A. I have tried the if function but can't seem to turn around to bring it to a zero value so I can still add the result for product codes I have pricing. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
/P Startup Switch in Excel 2000 | Joe | General Discussion | 1 | July 22nd, 2004 05:22 PM |
code method to switch views | scott | Using Forms | 4 | July 7th, 2004 11:19 PM |
Can't switch Identities | Bryan | Outlook Express | 3 | June 24th, 2004 08:32 PM |
Does not switch from VBE to Access Main Window | Tony_VBACoder | General Discussion | 1 | June 4th, 2004 04:20 PM |