USFengBULLS
Board Regular
- Joined
- May 7, 2018
- Messages
- 66
- Office Version
- 365
- Platform
- Windows
Hello All,
I have a Transmittal column on a Drawing Schedule worksheet that I want to auto populate whenever users add transmittal data (This is being done by VBA Already and is working fine) to another sheet that is the Transmittal Log. some things to be aware of, this vlookup has to meet three criteria, the Drawing Number, the Drawing Description and the Location.
On Drawing Schedule Sheet:
Column A=DWG NO
Column B=DWG Desc
Column C=Location
Column D= My lookup formula =IFERROR(IF(A11&B11&C11="*",VLOOKUP(A11&B11&C11,CHOOSE({1,2},'TRANS. LOG'!$B$11:$B$500&'TRANS. LOG'!$C$11:$C$500&'TRANS. LOG'!$D$11:$D$500,'TRANS. LOG'!$A$11:$A$500),2,0),""),0)
On Transmittal Log Sheet:
Column A=Transmittal Number
Column B=DWG NO
Column C=DWG Desc
Column D=Location
I had it working for a second but now it is not, Even if I have data In A11&B11&D11.
I have uploaded the file to a dropbox link. If you take a look on the drawing schedule sheet, the two items with drawing number 02 should have transmittal 1 and a date in the submitted column. Look at the Trans. Log sheet and these two are exactly the same over there.
Can anyone give me a hand with this, Thanks!
https://www.dropbox.com/s/8hoptgpp01gwwjf/MR Drawing Transmittals Master Form 2019 v1.0.xlsm?dl=0
I have a Transmittal column on a Drawing Schedule worksheet that I want to auto populate whenever users add transmittal data (This is being done by VBA Already and is working fine) to another sheet that is the Transmittal Log. some things to be aware of, this vlookup has to meet three criteria, the Drawing Number, the Drawing Description and the Location.
On Drawing Schedule Sheet:
Column A=DWG NO
Column B=DWG Desc
Column C=Location
Column D= My lookup formula =IFERROR(IF(A11&B11&C11="*",VLOOKUP(A11&B11&C11,CHOOSE({1,2},'TRANS. LOG'!$B$11:$B$500&'TRANS. LOG'!$C$11:$C$500&'TRANS. LOG'!$D$11:$D$500,'TRANS. LOG'!$A$11:$A$500),2,0),""),0)
On Transmittal Log Sheet:
Column A=Transmittal Number
Column B=DWG NO
Column C=DWG Desc
Column D=Location
I had it working for a second but now it is not, Even if I have data In A11&B11&D11.
I have uploaded the file to a dropbox link. If you take a look on the drawing schedule sheet, the two items with drawing number 02 should have transmittal 1 and a date in the submitted column. Look at the Trans. Log sheet and these two are exactly the same over there.
Can anyone give me a hand with this, Thanks!
https://www.dropbox.com/s/8hoptgpp01gwwjf/MR Drawing Transmittals Master Form 2019 v1.0.xlsm?dl=0