Forum Discussion
Solved
Return value form list based on value of another cell
Hi Link to document: https://1drv.ms/x/s!AipojThikVxRgiRC0t__L2g9jnrH?e=6f584M I have a list of two columns (in sheet Award Data): Column 1 is Awards Column 2 is hours. Each award is...
You can use
=INDEX('Award Data'!A2:A31,MATCH(F4,'Award Data'!B2:B31))
If you have Microsoft 365 or Office 2021, an alternative formula is
=XLOOKUP(F4,'Award Data'!B2:B31,'Award Data'!A2:A31,"",-1)
By the way, the formula in K6 can be shortened to
=MIN(SUMIF(C:C,I6,D:D),10)
I've added it to the OP and updated references etc.
Thanks
You can use
=INDEX('Award Data'!A2:A31,MATCH(F4,'Award Data'!B2:B31))
If you have Microsoft 365 or Office 2021, an alternative formula is
=XLOOKUP(F4,'Award Data'!B2:B31,'Award Data'!A2:A31,"",-1)
By the way, the formula in K6 can be shortened to
=MIN(SUMIF(C:C,I6,D:D),10)