Forum Discussion
XLOOKUP search w/multiple output
Hello,
I just saw that it was up today. I was unable to find a way to edit it after I hit submit. My apologies for not being clear.
I would like to be able to enter a number in one of the top two fields in the blue form and have the results populate the bottom three boxes.
//=XLOOKUP(H8,A2:A10606,B2:B10606)
the above formula is/was in the field next to D365 Part#.
It is dummy data at the moment only because I don't want to post the real data just in case it is proprietary. The real data will be setup exactly the same.
The only thing that has gotten me close to my goal is having some sort of XLOOKUP in every "white" field in the blue form. I know there has got to be a better way.
Thank you for any assistance/insight.
https://docs.google.com/file/d/1VmFb2bHvvyGhXktnsOfWiJ0S-bo0_tVX/edit?usp=docslist_api&filetype=msexcel
A macro/VBA routine probably could be used to place data in the white fields. Formulas put data in the space with the formula. Just as yours does now. But once a formula has been written, it's good to go. I personally don't like to use (and don't) macros, preferring by far to write formulas.
Without knowing how this is going to be used over the longer term, I'd revise it slightly to make clear that data entry is only in the yellow background cells (a useful convention to adopt). Right now it's set up so you can enter things in either or both. You may run into problems from time to time as it appears that some of your numbers are entered as numbers, others as text. To be consistent, given the variety of formats of D365 numbers, you should keep them all as txt.