Forum Discussion
Lookup Cost in Another Table
Solution SageHi Anonymous ,
You can split the unit number column, then create a custom column of the incident number and unit number as the index column, then create the same index column on another table, and finally use the LOOKUPVALUE function.
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-joesh-msft , Many thanks for your quick response. I have reviewed your solution and it seems to be heading in the directionthat I am looking for. However, I think the document I shared did not show you both tables. I have the cost table already prepared and i think you may find it in the first googledrive document. So that means I have table 1, which is what you demonstrated your solution, and I have table 2 which has my pre-made cost table from which I wish to look up cost by incident and unit numbers. I think if you look at the second table up, it will put your solution in context.
The goal is to look up each unit number by the cost set up in the second table. NB, THE SECOND TABLE DOES NOT HAVE UNIT NUMBERS, It shows the vehicle unit number and the cost of operating each. Please review that and let me know if you find it. If not ,I will send it again.
Many thanks and hope to read from you soon.
- v-joesh-msft
Hi Anonymous ,
I did not find the second table. The two tables you shared seem to be the same. Could you please share your other table?
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.