|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How to add a cell value to VLOOKUP?
Thank you, I'll give it a try.
"Max" wrote:
You would need to fix the points to A1 & A2 in the INDIRECT, since the concat
string is supposed to resolve to the table array, which is meant to be fixed
for propagation purposes.
In your expression, try amending your table arrays:
INDIRECT(Inventory!$M"&Formula!A1&":$W"&Formula!A2 "
INDIRECT(Inventory!$M"&Formula!G1&":$W"&Formula!A2 "
to these:
=INDIRECT("Inventory!$M"&Formula!$A$1&":$W"&Formul a!$A$2)
=INDIRECT("Inventory!$M"&Formula!$G$1&":$W"&Formul a!$A$2)
It should work fine
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"engel59" wrote:
Thanks for the quick reply.
If I placed A1 and A2 under tab Formula would the formula look like:
=IF(ISERROR(VLOOKUP(TRIM($H34),INDIRECT(Inventory! $M"&Formula!A1&":$W"&Formula!A2",11,0)),"Not
Found",VLOOKUP(TRIM($H34),INDIRECT(Inventory!$M"&F ormula!G1&":$W"&Formula!A2",11,0))
Would this be correct or do I have too many double quotes (") or ands (&)?
Do I need the dallor sign to lock it to that cell?
I would be doing a cut and paste down the row of the other cells.
|