View original (French)

How to combine two VLOOKUPs with an OR in Excel?

Solved
Noémie -  
Nomie2712 Posted messages 9 Status Member -
Hello,

I am working on creating an inventory file with stock exits.

There is a sheet in the workbook called "inventory" and a second sheet called "stock exit".

In my inventory sheet, each product has two references: the box reference and the supplier reference.

I would like to use a "VLOOKUP" function along with an "OR" to search for the product title based on either of the two references.

Currently, I am unable to do this. I typed this:
=OR(VLOOKUP(A2,Inventory!B2:C290,2,FALSE),VLOOKUP(A2,Inventory!A2:C562,3,FALSE))

I know how to use both formulas separately but not together... apparently not at all.

Could you please help me?

Best regards,

Noémie

Configuration: Windows / Internet Explorer 11.0

4 answers

  1.
    thev Posted messages 2013 Registration date   Status Member Last intervention   725
     
    Hello,

    Try to replace the "OR" with "IFERROR"

    --
    0
    1. Noémie
       
      It only works for one of the two references.
      As if there were only one active VLOOKUP.
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      you should upload a working file with what you've done because the proposal from Thev seems correct.
      cjoint.com and paste the provided link here.
      Eric
      0