VLOOKUP & IF STATEMENT Used Together

[bloodmilksky]

1. Hi Guys,
   
   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 (Below)
2. =IF(OR(ISNUMBER(SEARCH({"LFQXLXR","LCLARCX"},Sheet1!A1))),"Made To Order")
3. But Wont work when I try them together.
4. VLOOKUP(D2&E2,'PRODUCTS*IF(OR(ISNUMBER(FIND({"NXR","RCX387"},XR))),"MTO","AWAITING")
   
   
   Any help would be great

 

[Special-K99]

The range to lookup begins 'PRODUCTS...

1) Where's the closing apostrophe?
2) Why do you have an asterisk in the formula, you're making it appear as though that's part of the filename, ie 'PRODUCT*MTO' or 'PRODUCTS*AWAITING'
3) You havent referenced the column you want to return in the VLOOKUP
Format is VLOOKUP(lookvalue, range, column, match)

Try changing it to & and inserting the closing quote wherever it needs to be.
You're probably better off listing the various ranges you need to lookup.

 

[bloodmilksky]

Hi,

I have used name referencing to shorten the formula "Products" so Vlookup is looking in products for the product and the date.
but I wanted the IF Statement to work so that if an XR popped up it would return MTO

I do appologise its my first post so very new to this. would there be a problem though of me posting the ranges online?