First Match & Return Cell to Left

**djc123** · 10-05-2021, 10:28 AM

Hi there,

I would like a forumla that searches a whole row for the first value of 1/100%. I would then like the cell one cell to the left returned.

I have added some notes in blue to the attached sheet, for your reference.

Many thanks,

Danny

**AliGW** · 10-05-2021, 10:31 AM

Try this:

=--SUBSTITUTE(INDEX($A$1:$S$1,MATCH(100%,$B$1:$T$1,0)),"Month ","")

**djc123** · 10-05-2021, 10:52 AM

Wonderful! Thank you

**AliGW** · 10-05-2021, 10:53 AM

Thanks for the rep.

First Match & Return Cell to Left

LinkBack

Thread Tools

Rate This Thread

Display

First Match & Return Cell to Left

Re: First Match & Return Cell to Left

Re: First Match & Return Cell to Left

Re: First Match & Return Cell to Left

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] INDEX and MATCH, failing to return value using the LEFT function in the formula

[SOLVED] Nested IF/THEN with INDEX MATCH and return LEFT value

[SOLVED] Using LEFT inside INDEX-MATCH to find values that match first 5 letters of referenced cell

[SOLVED] INDEX/MATCH? - Return Value to left with IF function

[SOLVED] Index + Match to return result with Left function

Match Large, Return value in column to left

Using LEFT to return MATCH

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions