Thanks you all for your help,
Martin adding Value did the trick, I can now catch up on the two days work I
spent trying to figure it out,
Cheers
Adam

"adamb2000" wrote:

Hi,
I have created a VLOOKUP function which looks up a value in a different
Workbook.

Bases on this returned value I would like to create a VLOOKUP which looks up
a value in the original workbook but a different worksheet.

My problem seems to be creating a VLOOKUP on a formula. Below is what I
have used so far.

Original
=IF(D170,VLOOKUP(D:D,'[printing.XLS]TO GO'!$B:$H,4,FALSE),"TM")

Now I need to create a VLOOKUP on that result but it keeps returning #N/A.

Cheers,
Adam