PageArea referencing a text value

F

fontsie

Hello All,

I have been searching around all day and didn't see a way of doing
this, so I thought I post to find an answer.

I have a worksheet that will be used as a reference, let's call it
ref_file.xls

In this file, I have multiple Print Areas: PrintArea1, PrintArea2,
PrintArea3, etc.

In another file, example.xls, I have a worksheet that has 3 columns:

Column A is a text field
Column B is a number
Column C contains a VLOOKUP formula

The formula in Column C will look like this:
=VLOOKUP(B1, 'ref_file.xls'!PrintArea1,5)

This works fine, but I was wondering how I can have the "PrintArea"
value be that of Column A.

In other words, if A1 contains the text "PrintArea1", how can I insert
that value into the VLOOKUP formula in Column C?

Let me know if you need a better explaination.


Thanks in Advance,
 
Top