On Sunday 20 May 2007, JosephK wrote (regarding [users] LOOKUP reference problem): > Is it possible to use the contents of a cell as the column or row index > reference in VLOOKUP or HLOOKUP? > > My scenario is I have a table of 5000 customers with contact details > etc. Another table holds prices for about 300 different products. Each > customer or group of customers has a different price list according to > negotiated contracts. > > One field of my customers table holds the particular price list that > customer uses and the Prices table has fields for the different price > lists (Approx 50 different lists). > > I am trying to do a lookup such that I enter a product and get the price > of that product from the relevant price list. I've tried using HLOOKUP > within a VLOOKUP using the customers pricelist field as a column > reference but this does not work.
Joseph As far as I can see, the vlookup and hlookup functions work on Arrays of adjacent cells. I do not think I can get them to work across tables (or different/disjoint arrays). So, I think you need to use some other "magic" to get this to work. Probably you could use a Pivot table, or formula which can work on Arrays. If you are so inclined to do so, send me a sanitized version (no ACTUAL personal, price information) of your spreadsheet. Tell me what your expectations are, and what output you expect to see. Please send it to me OFF THE LIST, and I will see if I can help. -- Pradeep Srinivas Bangalore, India --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
