I need to lookup a value from another workbook. I need it to be the last
alpha-numeric value entered in a column. The only thing is that I need it to
pull the value from 3 different sheets with in a work book depending on the
value entered in a cell in sheet 1. Here is an example to help you understand.

Book 1

C2 needs to be the value pulled from the other workbook.

J7 has a posibility of being either silo 1, silo 2, or silo 3.

If J7 equals "silo 1" I need it to pull the last alpha numeric from the
sheet labeled "silo 1" in "book 2"

Help me if you can.

So in C2 you need nested if then else formulas referencing the value in J7 to
determine where to get the external data from. Interms of getting that data
take a look at this link to get the last value...

http://www.xldynamic.com/source/xld.LastValue.html
--
HTH...

Jim Thomlinson


"BAKERSMAN" wrote:

I need to lookup a value from another workbook. I need it to be the last
alpha-numeric value entered in a column. The only thing is that I need it to
pull the value from 3 different sheets with in a work book depending on the
value entered in a cell in sheet 1. Here is an example to help you understand.

Book 1

C2 needs to be the value pulled from the other workbook.

J7 has a posibility of being either silo 1, silo 2, or silo 3.

If J7 equals "silo 1" I need it to pull the last alpha numeric from the
sheet labeled "silo 1" in "book 2"

Help me if you can.