Lookup newest value from a column in another workbook

So I have a daily report I have to compile that pulls data from several workbooks and various pages withing those workbooks.

For example, I need to pull the newest non text entry from coulumn b, on page Water & Oil, in workbook CTB Test Book 2.

How do I put in that formula?

All help is appreciated.

Welcome to the forum.

Adding a workbook link to a formula is detailed here:

https://trumpexcel.com/reference-ano...kbook-in-Excel

Then use this as your formula:

=LOOKUP(2,1/(ISNUMBER(B:B)),B:B)

Replace B:B with the full worksheet reference as per the link.

So either:

='[CTB Test Book 2.xlsx]Water & Oil'!B:B

or:

='C:\Users\someone\Desktop\[CTB Test Book 2.xlsx]Water & Oil'!B:B

Added like this:

=LOOKUP(2,1/(ISNUMBER('[CTB Test Book 2.xlsx]Water & Oil'!B:B)),'[CTB Test Book 2.xlsx]Water & Oil'!B:B)

or:

=LOOKUP(2,1/(ISNUMBER('C:\Users\someone\Desktop\[CTB Test Book 2.xlsx]Water & Oil'!B:B)),'C:\Users\someone\Desktop\[CTB Test Book 2.xlsx]Water & Oil'!B:B)

Glad to have helped.

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.