08-14-2020 12:04 AM
08-14-2020 03:32 AM
Here is a small demo with one of the possibilities.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
I know I don't know anything (Socrates)
08-14-2020 11:06 AM
08-14-2020 10:52 PM
@Omargrajales I believe the classic VLOOKUP function does what you need. Though, it depends on how your data is structured. A combination of INDEX and MATCH or new functions like XLOOKUP and FILTER may also be used, provided that you are a Microsoft 365 subscriber.
I've attached a small file to demonstrate each of the above. All of it can be made more dynamic by using named ranges and structured tables that contain your data, but I didn't go into that for now.