offset a looked up cell
I have a file with two worksheets, "quote form" and "database". An employee
enters in an item # in cell B1 of "quote form" and I have written a vlookup
function that returns the address of that item on "database" into cell C1 on
"quote form."
Here's my problem: the price of the item on "database" is 8 columns over
and 2 rows down from the item number. When I write an offset function on the
"quote form" worksheet excel offsets that cell and not the address in it.
Any suggestions??
|