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

[TABLE="width: 1203"]
<tbody>[TR]
[TD]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
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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")