VLookup - which cell am I looking at?

[tim.smith]

I have an Excel XP workbook with two worksheets, Front & Back. Th
"Back" worksheet contains a grid of data (lets say, for sake o
argument that the rows represent vendors and the columns total sales b
year with a separate column for each year).

On the Front page, I am using the VLookup function to populate
similar grid. When a user enters a value into a cell (lets say fo
Vendor1 the total sales for 2004), I want to take that number an
update the corresponding cell on the "Back" page.

I was thinking of using the Change event to capture the new value an
"post" it to the other page. My question is this: how can I determin
the correct row on the "Back" page (the front and back pages are no
necessarily sorted the same way)? I know the column by virtue of th
original VLookup function that was in the cell prior to the use
entering a new value.

I was thinking of using the VLookup function in the macro code, bu
would need to get the row number of the cell being referenced.

Any ideas?

Thanks
Tim Smith
Senior Analyst/Application Development
Advance Magazine Group
Wilton, C

 

[Charles Williams]

Hi Tim,

sounds like you need to be using MATCH which returns the row number.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm