Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |