TITLE: VB Scrip Help - IF CELL EQUALS VALUE THAN RETURN VALUE FROM COLUMN WITH SAME TITLE
I am looking for help to
write a formula or script for the attached work document
The Goal is to reduce the amount of time I have to expend
looking for bracket price for an item, based on the type of business:
Currently I have these business types:
each type has a different price for the same item:
so I am trying to update cells
this is the logic for what I need to achieve:
IF P24 = Empty "DO NOTHING"
IF P24 = same value as O24 ,
THAN GO to CELL N24
IF N24 = Empty "DO NOTHING"
IF N24 "VALUE" is equals to "EXPORT" (Example)
LOOKUP "N24 VALUE" in cells "R23:AC23" (Column Title)
THAN RETURN PRICE FOR ITEM NUMBER ON P24
FROM COLUMN WITH SAME TITLE "EXPORT"
Example: Y24 = should bring price of $40 to cell Q24
DO THE SAME FOR ALL ROWS Q24:Q47
THERE ARE TWO WORKSHEETS IN THIS WORK DOCUMENT.
ONE HAS CALCULATION SHEET "Fill_IF_SEGMENT_ID" other are the Prices to return "SEGMENT_ID"