Vlookup Formula to return "Item in stocK' if there is a match or "not in stock" if no match

[howard]

I have the following formula below

 =IF(IFERROR(VLOOKUP(A5,'[Group Stock Report.xlsm]shirts'!$J:$J,COLUMNS(J:J),FALSE),VLOOKUP(A5,'[Group Stock Report.xlsm]Trousers'!$I:$I,COLUMNS(I:I),FALSE))="","Item in stock","item Sold")

The ref number in the source file is in Col A

Kindly amend my formula so that where the ref in Col A matches the ref for Shirts in Col J or trousers in Col I then return "item in stock" or "item sold"


Your assistance in this regard is most appreciated

 

[mikerickson]

How about

=IF((IFERROR(MATCH(A5, '[Group Stock Report.xlsm]shirts'!$J:$J, 0),0)+IFERROR(MATCH(A5, '[Group Stock Report.xlsm]trousers'!$I:$I, 0),0)) > 0 , "item in stock", "item sold")

 

[AlanY]

try

=IF(AND(ISERROR(VLOOKUP(A5,'[Group Stock Report.xlsm]shirts'!$J:$J,COLUMNS(J:J),FALSE)),ISERROR(VLOOKUP(A5,'[Group Stock Report.xlsm]Trousers'!$I:$I,COLUMNS(I:I),FALSE))),"item Sold","Item in stock")

 

[howard]

Thanks for the help. Both of your formulas works perfectly