Hi all
In the sheet I've attached, I'm trying to match two values, and if they match, return a third to where the formula is. For example:
"If J2 in CIU matches A2 in FRAMEWORKS and Q2 in CIU matches B2 FRAMEWORKS, then K2 CIU will be C2 FRAMEWORKS."
The cell I need to have the return value in is highlighted in the attached sheet.
Any questions, fire away and as always - any help is greatly appreciated
(I've got a formula in K2 already which I can't get to work)
Book1.xlsx
Last edited by Aaron092; 10-01-2014 at 07:22 AM.
In K2 Cell of CIU Sheet - Array Formula - Requires CTRL+SHIFT+ENTER
=IFERROR(INDEX(FRAMEWORKS!$C$2:$C$10,MATCH(1,(FRAMEWORKS!$A$2:$A$10=J2)*(FRAMEWORKS!$B$2:$B$10=Q2),0)),"")
Drag it down...
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you Sixthsense. Come to my rescue again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks