Looking up information in multiple ranges

[KerryKelly]

Hi,
I need help creating a formula to identify a store within a range and to then look at the products stocked by that store returning a yes or no as to whether they stock the item and I'm really struggling with the best way to do this. Any help gratefully received!

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[KerryKelly]

Thanks for the tip!

[GeoffW283]

In E4 copied down and across:

Please Login or Register  to view this content.

[KerryKelly]

Thanks Geoff, you are a life saver! I have spent hours trying to figure that out and I definitely wouldn't have come up with this as a solution! Thank you so much!

[GeoffW283]

No problem - glad to help!