View original (French)

How to combine two VLOOKUPs with an OR in Excel?

Solved
Noémie -  
Nomie2712 Posted messages 9 Status Membre -
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 réponses

Réponse 1 / 4
thev Posted messages 2007 Registration date   Status Membre Last intervention   722
 
Hello,

Try to replace the "OR" with "IFERROR"

--
0
Noémie
 
It only works for one of the two references.
As if there were only one active VLOOKUP.
0
eriiic Posted messages 24581 Registration date   Status Contributeur 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