How Old You Have To Be To Work At Autozone

Josep Huguet writes from Barcelona.

I take a couple of days looking for solution manuals and looking but I know almost nothing about programming and I'm a bit lost. See if you can help me with this problem: I have five customers in an Excel workbook on the first sheet, the second sheet I have the stock of products for each client, I would like to display on the first page of each customer stock I entered the client code. Thank you very much for your attention. Josep

need to put the customer number on the first page and automatically displays stock loaded in the second page.





The problem is solved with nested IF functions with VLOOKUP.

= IF ($ B $ 11 = 1, VLOOKUP (A1 STOC!; STOC! A1: C10, 3, 0), IF ($ B $ 11 = 2, VLOOKUP (A3 STOC!; STOC! A1: C10, 3; 0), IF ($ B $ 11 = 3, VLOOKUP (A5 STOC!; STOC! A1: C10, 3, 0), IF ($ B $ 11 = 4, VLOOKUP (A7 STOC!; STOC! A1: C10, 3; 0), IF ($ B $ 11 = 5, VLOOKUP (A9 STOC!; STOC! A1: C10, 3, 0 ))))))

STOC! is the sheet where the stocks for each client.

scares formula, but it works. Anyone who knows a little
EXCEL going to be able to decipher.