Using cell text in a formula

  • Thread starter Thread starter Dale Jim
  • Start date Start date
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
 
Hi Jim,

You are on the track with INDIRECT.

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

HTH
Anders Silven
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i use the text in a cell as a named range in a vlookup form 2
Copy a formula using Vlookup 2
Combining Text From Cells 3
Copy part of VLOOKUP formula? 4
Find and replace a value within a formula 2
Excel formula, sum the value cell and if empty cell left blank 0
Using text from cell in a range lookup 1
Display only unique values in CONCATENATE formula 4

Back
Top