Formula help with index/match thanks!

[petsean007]

I everyone there is an attachment to this post
basically im trying to..


Match Sheet 2 column F "Current Status" to Sheet 1 Row O1 to U1 based on Company/Investigation.

so.. Sheet2: Investigation #1 Current Status populates in Sheet 1 Investigation #1

Then

Sheet2: Investigation #2 Current Status populates in Sheet 1 Investigation #2

Based on Company A Company B etc

Thanks!


formula I have so far is (=INDEX('Sheet 2'!$F$2:$F$100,MATCH($A2,'Sheet 2'!$D$2:$D$100,0))) but I cant figure out the rest

[FlameRetired]

Hello petsean007. Welcome to the forum.

There is a typo in Sheet1 A8 ... a missing space. Once corrected try this in O2:U3 of Sheet1.

Please Login or Register  to view this content.

[Bo_Ry]

Please try at O2 drag across and down

=IFERROR(LOOKUP(2,1/('Sheet 2'!$D$2:$D$100=$A2)/('Sheet 2'!$A$2:$A$100=O$1),'Sheet 2'!$F$2:$F$100),"")

Sheet 2 A8 , add space before " #1"

[petsean007]

Thankyou Bo_Ry worked out perfectly! been stuck on it for a couple of days now and I really appreciate the help,

[Bo_Ry]

Happy to help

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.