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??

Assuming that Database!A1:I10 contains your database/source data, try...

=INDEX(Database!B1:I10,MATCH('Quote Form'!B1,Database!A1:A10,0)+2,8)

Adjust the range and sheet references accordingly.

Hope this helps!

In article ,
"tiggz13" wrote:

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??

Why not add a new column to your database and move the 'price' to the same
row as the 'item number'?

"tiggz13" wrote:

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??