VLOOKUP & IF STATEMENT Together to Produce different values

[bloodmilksky]

Hi Guys,

My first post so I thought I better make it a good one

I am trying to run a report for dates for product supply and so far I have managed to use VLOOKUP to bring me back the dates for all of the products I am reporting but I now want to improve the report by providing a value other than dates such as " made to order" for products that have XR in them.

ex: LTMVXR60052590 MADE TO ORDER

I have managed to get the Made To Order returned by using IF statement by itself but wont work when I try and intergrate VLOOKUP & IF


I believe that the way to do it is to somehow merge the below formulas together maybe using wildcards

VLOOKUP(D2&E2,'PRODUCTS*IF(OR(ISNUMBER(FIND({"NXR","RCX387"},XR))),"MTO","AWAITING") this is also over 2 tabs/sheets and I have used name referencing "PRODUCTS" any help would be greatly appreciated

<tbody>
</tbody>

 

[bloodmilksky]

if you have any questions please ask and the IF statement I used is

=IF(OR(ISNUMBER(SEARCH({"LFQXLXR","LCLARCX"},Sheet1!A1))),"Made To Order")