XL 2019 VLOOKUP doesn't work

[Vz25]

Hello,

I am required to create VLOOKUP formulas in the second sheet in the attached doc, i tried the following: =VLOOKUP(B18, Table_1, 9, False) but it doesn't work, i'm not sure what is wrong.. if anyone can give me some pointers regarding this as well as indirect arrays in Sheet 3 i would greatly appreciate it. Many thanks.

Vera

 

[sylvanu]

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

=VLOOKUP(B18, Table_2, 9, False)

The result is 529. ( cell J7 )

 

[Vz25]

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

 

[sylvanu]

Hi Vz,

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

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 ?

 

[Vz25]

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"..

 

[sylvanu]

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.

 

[Vz25]

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.

 

[Phil69970]

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

 

[Vz25]

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..