gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I have this formula that someone on this site was very kind to provide.
But there seems to be a problem with formatting that stops it from working sometimes.
=FILTER(SQD[SourceID],(SQID[@[ItemID - Trimmed]]=SQD[PartNumberTrimmed])*(SQID[@VendorQuoteID]=SQD[Vendor Quote ID]),"")
If i click in the appropriated cell for SQID[@VendorQuoteID], change it to Text, click in it and then change the field back to general, then the formula works. It seem as if the formula cannot find it because of how its formatted. Not sure. It is working for about 85% of the cells the formula is in. But for the other 15% I am having to go back and forth and manually clicking in fields to get the formula to pull the results.
Any suggestions?
But there seems to be a problem with formatting that stops it from working sometimes.
=FILTER(SQD[SourceID],(SQID[@[ItemID - Trimmed]]=SQD[PartNumberTrimmed])*(SQID[@VendorQuoteID]=SQD[Vendor Quote ID]),"")
If i click in the appropriated cell for SQID[@VendorQuoteID], change it to Text, click in it and then change the field back to general, then the formula works. It seem as if the formula cannot find it because of how its formatted. Not sure. It is working for about 85% of the cells the formula is in. But for the other 15% I am having to go back and forth and manually clicking in fields to get the formula to pull the results.
Any suggestions?