Dear Expert
I have data which need to validate and replace the value depend upon multiple filtering
Filter#1
IF BL = LAG,
Filter#2
IF BG = OCOGS - Spares - Transfer Price Overhead and OFSS - ORCL Consulting Prod Cost I/C.
Filter#3
IF AY = BOA_033E OR BOA_011G, Replace in BG Col with OCOGS - Spares - Transfer Price Overhead
Rest of all = OFSS - ORCL Consulting Prod Cost I/C
Find the Attachment
Hi there,
Not sure about your 'expected outcome' for rows 2 & 3 as the first filter in column BL is not LAG, hence not met.
Try the attached file.
The code below will output the result in column 'BN' for testing. Just update 'BN' with 'BG' once happy with the code.
Please Login or Register to view this content.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
Is that your actual file setup...All those blank Column Headers...
No need for loop or filter...Can be replaced in one go I'm guessing...
Last edited by sintek; 03-26-2023 at 06:08 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Solved ORoss!! Thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks