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:
GOV_EDU_PUBLIC_BID
BSC_COMMERCIAL
HEALTHCARE
LODGING_HOTEL_RESORT
ENTERTAIMENT_TRAVEL
FOOD_SERVICE
RETAIL_CASH_CARRY
EXPORT
NON_PROFIT
PORT_A_TOILET
ASCTD_DISTR_via_RD
RD_SE_Price
each type has a different price for the same item:
so I am trying to update cells Q24:Q47
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
FOR YOUR INFORMATION :
THERE ARE TWO WORKSHEETS IN THIS WORK DOCUMENT.
ONE HAS CALCULATION SHEET "Fill_IF_SEGMENT_ID" other are the Prices to return "SEGMENT_ID"
Bookmarks