Hello, I am looking for a formula that will allow me to look across 4 tabs (INV,INV2,INV3,INV4) within the same cell range (D74:X74) and simply return the last numerical value within the range. These cells will be populated every day, but I simply want it to return the last cell with a numerical value (i.e. one that isn't blank). I have tried LOOKUP, but can't get the syntax right for it to look across multiple tabs. Any help would be greatly appreciated. Thanks in advance.

I'm not quite sure what you are asking for. Are you asking for the value in the last cell in

eachsheet or the last value acrossallsheets?In other words, if one of the sheets has a value in, for example, T74, all the other sheets will have values in S74 and below and you only want the value from the sheet with something in T74.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Hello, I am looking for the last cell across all sheets. The sheets are all the same format, but contain numerical entries according to date, so as time goes by, more and more entries are necessary. I only want say, T34, even though T1-T33 contain entries. Also, the entries are in no order (lowest to highest, etc). I only want the last numerical value across ALL sheets. Thank you in advance.

Maybe it's me, but I'm still not sure if you want 4 values (one from each sheet) or just 1. In your OP you asked for the last cell in the range D74:X74, which is a horizontal range in the same row, but now you are asking for the last value in T1:T33, which is a vertical range in column T.

I, for one, am confused as to what you want.

Perhaps you should post some examples of your data and the desired output based on that data.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History