Think VLOOKUP or INDEX/MATCH would be 2 usual ways ..

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SalmatMikeG" wrote:
Hi,
I need to :
- Take a value on the same row as the formula
- Look-up that value on another workbook / worksheet
- Return a value in on the same row as the value in the other sheet

Can this be done ?

Regards
Michael