Full workbook lookup form

Hi



I am currently trying (and failing) to identify the correct formula to return a price from a workbook with multiple sheets.

I want it to search the full workbook for the product code (RJL Code) and return the price for a particular month.



Any help would be appreciated.?* I have attached a sheet highlighting the info required.

I don't understand. Where (on which tabs) are we meant to search for these prices? I don't see any raw data.

If you want something on that blank sheet, then you'll need to manually mock up what that is.

OK - so you need to give us a mock-up (instead of a blank sheet) where you want this to happen.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Are you still using Excel 2019?

OK - we're getting there (slowly). I've asked about your Excel version - could you confirm that, please (as it will determine how easy or hard this needs to be)?

You've removed everything we need for the lookup from the latest workbook! Is this meant to be two workbooks, or is everything in one?

If the latter, please provide a workbook with everything in it, please.

The layout of the Company 1 sheet is different to the other two - can this follow the same format?

Try this in C4 copied down:

Please Login or Register  to view this content.

This will be easier if you have Excel 2021, 2024 or 365.

OK - so use the formula in post #9, but adapt it so that the other workbook is being referenced for the company sheets. You should be able to do this yourself, I think.

I've done the cross-sheet reference in the attached.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward 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 each of those who offered help.

It makes more sense (to me) to have all of it in one sheet (see post #9).

If you want two sheets, see post #9 for the source sheet and post #13 for the lookup sheet.

With 64 tabs, nesting formulae for each tab is going to become a pain. So, you either need to upgrade to 365 (not likely if this is a company's software), or think of VBA. However, I have answered the original question in two ways, so please follow my instructions to mark the thread as solved and if necessary, start a NEW thread in the VBA section.