This is a tricky one

  • Thread starter Thread starter gymbag
  • Start date Start date
G

gymbag

I'm trying to use a formula to automatically display a cell value from
different worksheets in Excel 97 (ie, I want to display cell D28o
another sheet, and the reference cell is found in A26. I can't seem t
use VLOOKUP because the value I'm using as a reference point is on
different row than the reference (same problem for HLOOKUP). LOOKU
seems too general to do the job. I attempted to create a neste
function using OFFSET, but couldn't manage to figure it out. An
suggestions? Any assistance would be greatly appreciated
 

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

OR AND VLOOKUP 10
Offset with hlookup as reference 2
This One Is Tricky Need Help !!!!! 1
HLOOKUP - Relative cell reference in row index number 0
This is a tricky one 1
This is a tricky one 1
Please help with a formula 6
VLOOKUP and Wrap Text 5

Back
Top