Someone, please help.
I don't know how to set up formulas to find the values needed in my table.
I don't know what is best to use to figure this out.
Appreciate the guidance.
Thanks!
Someone, please help.
I don't know how to set up formulas to find the values needed in my table.
I don't know what is best to use to figure this out.
Appreciate the guidance.
Thanks!
Last edited by DesertMJ; 02-24-2021 at 03:00 AM. Reason: Poorly written request.
I'm confused, and once again, you haven't helped with a pretty vague title, which will need changing. Is this about lookups or conditional formatting, or both?
In your sample workbook you need to MOCK UP the answers and formatting you want to see manually - do this and I'll have another look, and update your title to tell us what it is you are trying to achieve, not how you think it should be done.
You have another thread open where you've received help and advice - please make sure you acknowledge that help and mark the thread as solved, if it is. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have re-titled, re-written and adjusted the file as well.
Appreciate the help.
Try below formula in F5, Copy and paste across
=LOOKUP(2,1/((Sheet1!$B$5:$B$24=$B5)*(Sheet1!$C$5:$C$24=F$4)),Sheet1!$D$5:$D$24)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Working to apply to my actual document and confidential info. Be right back. 1216am MST.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks