Help with lookup or Index formula excluding certain data.

[ODP]

I'm trying to write a formula that will look in COL J for an identifier "S", if it does have that identifier I than need it to lookup data in COL I and return a result that DOES NOT have a "S" in COL J. ALso, COL H has invoice #s.

=IF(J:J<>"S",I2,index(???)

Thanks in advance!

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Sam Capricci]

are you thinking to count or sum the values without the "S" identifier, or are you looking to do this row by row? And what does col H have to do with it?
from what you've written it sounds like this would work... =IF(J2="S","",I2)

[ODP]

added workbook

[Sam Capricci]

this looks like it will work for you... =IF(D2="",C2,IFERROR(LOOKUP(2,1/(""=$D$2:$D$18)/(B2=$B$2:$B$18),$C$2:$C$18),""))

[ODP]

this looks like it will work for you... =IF(D2="",C2,IFERROR(LOOKUP(2,1/(""=$D$2:$D$18)/(B2=$B$2:$B$18),$C$2:$C$18),""))

This seems to work beautifully, thanks so much!

[Sam Capricci]

You're welcome, glad it worked for you.