How to return a value from another workbook

N

Narnimar

I got a workbook named "Monitor Book" in which I need to lookup for the
targetvalue of a reference "ITEM" in cell a1 from another Book named as
"DATABASE". I will be updating the DATABASE every month so the ITEM and the
related figures in the cell keeps moving to downward rows. But the target
value of the ITEM in the DATABASE sheet will be always existing in the cell
which is 2 columns right side and 3 rows down even if its address changes its
cell location in the column A when I update the DATABASE sheet. I do not know
how to use the vlookup formula as the target value is in the 3 raws down and
2 columns right side.
So if the target value to be returned in cell a1 of Monitor Book from
DATABASE workbook looking for the reference ITEM and its target value what is
the formula.
Can anyone explain it with an worked example?
 

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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Auto populate value from one task to another in MS PROJECT 0
how to copy and paste value from one sheet to another 4
trouble with (complicated) vlookup searching another workbook 2
How to create absolue path link to another workbook (Excel 2003) 1
How to create absolute link to cell in another workbook (Excel 2003) 1
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
Vlookup and return sheet name also 2

Top