SOLVED

Drop down values

Copper Contributor
I’ve created a column where you select a certain generator, after you select on how do I attached values to it? Such as hourly fuel consumptions, oil needed, ect.
1 Reply
best response confirmed by Joseph1080 (Copper Contributor)
Solution

@Joseph1080 I assume you have the values you want to display for each generator, somewhere inside a table. Consider using VLOOKUP (or XLOOKUP) to find the value(s) for the selected generator. More about these functions here:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 

1 best response

Accepted Solutions
best response confirmed by Joseph1080 (Copper Contributor)
Solution

@Joseph1080 I assume you have the values you want to display for each generator, somewhere inside a table. Consider using VLOOKUP (or XLOOKUP) to find the value(s) for the selected generator. More about these functions here:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 

View solution in original post