Using cell text in a formula

D

Dale Jim

I am trying to use derived cell references in a VLOOKUP formula to matc
data in several tables. For example, A1 contains the cell reference fo
the top left of my array (A3) whilst cell A2 contains the cel
reference for the bottom right of my array (D14). The array I'
checking against starts in column E3.

However, when I use the formula =VLOOKUP(E3,A1:A2,4,FALSE) I get a #N/
error. I need to use the cell references in each VLOOKUP as the arra
sizes may vary in each case. (PS, I've used =INDIRECT(ADDRESS(A1,A2)
to derive the cell references.

Ji
 
A

Anders Silven

Hi Jim,

You are on the track with INDIRECT.

Try this
=VLOOKUP(E3,INDIRECT(A1&":"&A2),4,FALSE)

HTH
Anders Silven
 
Top