HELP! Need help with this formula...

  • Thread starter Thread starter soltek
  • Start date Start date
S

soltek

I have this code to match a certain part code...
=IF(ISNUMBER(MATCH(H7,BSCODES,0)),"S","D")
Unfortunatly, any row that doesnt contain information automaticall
tells this to place a D in the cell. Is there a way to fix thi
formula to say if there there is no part number in H7, to not lis
either S or D
 
Don't know what the "D" is supposed to represent in the first place.

Try:

=IF(ISNUMBER(MATCH(H7,BSCODES,0)),"S","")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have this code to match a certain part code...
=IF(ISNUMBER(MATCH(H7,BSCODES,0)),"S","D")
Unfortunatly, any row that doesnt contain information automatically
tells this to place a D in the cell. Is there a way to fix this
formula to say if there there is no part number in H7, to not list
either S or D?
 
change your "D" to "" and do something else to determine if D should be
placed.
=IF(ISNUMBER(MATCH(H7,BSCODES,0)),"S",if(something else,"D",""))
another approach might be to use isna
=IF(ISNA(MATCH(F1,E:E,0)),"","whatever")
 
Those formulas look great but they still dont seem to work. Im still
trying different variations but no luck yet..... hope you guys keep
trying, thanks for your help thus far
 
Hi
please post the exact formula you have tried as well as a detailed
description what does not work
 
Well this is the formula i am using right now
=IF(ISNUMBER(MATCH(H557,BSCODES,0)),"S","D")
It does do the job of identifying and matching the prodct codes in th
"BSCODES" list. however, in all cells and/or rows that do not contai
any data, these cells have a default of "D" apparently to me ita
because the end of the formula results a "D" in the FALSE position.
have tried all other formulas in this thread to no avail
 
Hi
try:
=IF(H557="","",IF(ISNUMBER(MATCH(H557,BSCODES,0)),"S","D"))

or
=IF(H557="","",IF(ISNA(MATCH(H557,BSCODES,0)),"D","S"))
 
Back
Top