XL 2019 VLOOKUP doesn't work

sylvanu

XLDnaute Barbatruc

Supporter XLD

• 7 Mars 2022

• #2

Hi Vz, welcome to XLD,
I understood.
In your formula I think it's not Table_1 but Table_2. Try :

VB:

=VLOOKUP(B18, Table_2, 9, False)

The result is 529. ( cell J7 )

 

Vote positif 0 Vote négatif

V

Vz25

XLDnaute Nouveau

• 8 Mars 2022

• #3

I'll try it, thank you so much. I was also wondering about indirect arrays, I don't really know what it means. Thank you again

 

Vote positif 0 Vote négatif

sylvanu

XLDnaute Barbatruc

Supporter XLD

• 8 Mars 2022

• #4

Hi Vz,

Vz25 à dit:

I was also wondering about indirect arrays, I don't really know what it means.

Cliquez pour agrandir...

Me neither. 🙂
What do you mean by indirect arrays?
"Indirect" is a XL formula allowing to find a cell address, but not necessarily linked to an array.
Could you precise your thought ? And in which case do you want to use it ?

 

Vote positif 0 Vote négatif

V

Vz25

XLDnaute Nouveau

• 8 Mars 2022

• #5

Hello, it's the third sheet in attached document. I have really never used it, I don't even know why they are asking for "indirect arrays"..

 

Pièces jointes

• Google+Sheets+exercise.xlsx

  82.7 KB · Affichages: 1

Vote positif 0 Vote négatif

sylvanu

XLDnaute Barbatruc

Supporter XLD

• 8 Mars 2022

• #6

Sorry, I can't help you on this point, I don't understand the question.
In particular to start with 5570.
If they want an invoice format in D5😀10 of sheet4 ( not in sheet 3 ), 5570 is the begin of the invoice number or an index to found the data ?
Sorry.

 

Vote positif 0 Vote négatif

V

Vz25

XLDnaute Nouveau

• 8 Mars 2022

• #7

Thank you anyways. It's a really weird question that I don't understand either. I thought that indirect arrays were supposed to generate some random invoice numbers based on the first invoice number - 5570.

 

Vote positif 0 Vote négatif

Phil69970

XLDnaute Barbatruc

• 8 Mars 2022

• #8

Bonjour @Vz25 , Sylvain

Nous sommes ici sur un forum français et il me semble que c'est au demandeur de se servir de google translate et non le contraire.
Merci d'écrire en français pour la compréhension de tous au lieu d'une seule personne.

@Phil69970

 

Vote positif 0 Vote négatif

V

Vz25

XLDnaute Nouveau

• 8 Mars 2022

• #9

Pardon, comme c'est un .com, je me suis dit que je pouvais écrire en anglais.. c'est une question par rapport à indirect arrays dans le fichier joint..

 

Vote positif 0 Vote négatif