CODEWITHSUNDEEP
excelreferenceformula
J. Doe
J. Doe

Reputation: 483

Excel: Use Cell Range which is saved in a cell for completing a formula in another cell

enter image description here

In the above Table i would like to use the range defined in V2 for the formula defined in E2. It should replace the green underlined part of the formula. As you can see there is already the right range in there but it is for flexibility reasons if the range changes so i don't have to change all the formulas which are in E2,F2,G2,... and so on.

The Formula: =VLOOKUP("contract index",INDIRECT("'PURCHASING'!"&V2),2,FALSE)

Upvotes: 0

Views: 30

Answers (1)

user4039065
user4039065

Reputation:

Try,

=vlookup("contract index", indirect("'purchasing'!" & v2), 2, false)

Upvotes: 2

Related Questions