LinkBack URL
About LinkBacks
From Table1 to Table2 two criteria , O3:O9 (blue color area need formula) is the answer I want
Can someone please help me ? It would be much appreciated
From Table1 to Table2 two criteria , O3:O9 (blue color area need formula) is the answer I want
Can someone please help me ? It would be much appreciated
Last edited by rayhen; 02-25-2022 at 04:31 AM.
In O3 copied down
=INDEX($D$5:$J$7,MATCH(L3,$B$5:$B$7),MATCH(M3,$D$4:$J$4,FALSE))
You'll need to add a #4 to your table otherwise you'll get an error in O7
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Try this
Cell O3 formula , drag down
Formula:
Please Login or Register to view this content.
@Richard Buttrey'S Thank you, I used WK9128'S formula to solve my problem, thank you both help
@rayhen You're Welcome. Glad to help . Thank You for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks