Hello All,
is there a way to do something like a vlookup based on whether an order has been cancelled;
Ie; tab 1 has a checklist to ensure we have everything in reference to an order number that gets pulled from the second tab but if an order number is cancelled it can be used again at a later date therefore the information that needs to get pulled is from the live order not the cancelled.
order number will be in column A in both tabs, whether an order is live or cancelled will be in column B on the second tab and we need data to be filled from column C in tab 2 into the 1st tab, is it possible as I know Vlookup will only check the one closest to the top i have tried to add some IF statements but not getting anywhere.
any help will be appreciated thank you
is there a way to do something like a vlookup based on whether an order has been cancelled;
Ie; tab 1 has a checklist to ensure we have everything in reference to an order number that gets pulled from the second tab but if an order number is cancelled it can be used again at a later date therefore the information that needs to get pulled is from the live order not the cancelled.
order number will be in column A in both tabs, whether an order is live or cancelled will be in column B on the second tab and we need data to be filled from column C in tab 2 into the 1st tab, is it possible as I know Vlookup will only check the one closest to the top i have tried to add some IF statements but not getting anywhere.
any help will be appreciated thank you