**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula that pulls the name of a column header based on inputs in a number of different rows... Please help thank you!

Solved by M. H. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/09/2018 - 03:40

Hi

User
23/09/2018 - 03:40

hello!

Excelchat Expert
23/09/2018 - 03:40

Welcome to Got it Pro

User
23/09/2018 - 03:40

thank you very much for your help

Excelchat Expert
23/09/2018 - 03:41

Do you have any excel sheet?

User
23/09/2018 - 03:41

i do!

User
23/09/2018 - 03:41

it is confidential, however

Excelchat Expert
23/09/2018 - 03:41

Oh. Can you create a sample data

User
23/09/2018 - 03:41

let me pull an example together to send you

User
23/09/2018 - 03:41

thank you very much

Excelchat Expert
23/09/2018 - 03:41

Thank you

User
23/09/2018 - 03:44

sorry for the wait...

User
23/09/2018 - 03:44

one second please

Excelchat Expert
23/09/2018 - 03:44

Sure. No issues

Excelchat Expert
23/09/2018 - 03:47

Are you there?

Excelchat Expert
23/09/2018 - 03:47

Instead of sending the details you can just type in our screen

User
23/09/2018 - 03:47

yeah i'm thinking about what i'm allowed to share...

Excelchat Expert
23/09/2018 - 03:48

Ok. As per my understanding you would like to get the header name

User
23/09/2018 - 03:48

okay so basically

User
23/09/2018 - 03:48

Sheet 1 has this table that i need to fill out

Excelchat Expert
23/09/2018 - 03:48

Yes.

Excelchat Expert
23/09/2018 - 03:48

Ok.

User
23/09/2018 - 03:49

Sheet 2 has a summary of all the offers we've received on this portfolio of properties

User
23/09/2018 - 03:49

obviously from different parties

Excelchat Expert
23/09/2018 - 03:49

Ok.

User
23/09/2018 - 03:50

I need to generate a Sheet 1

User
23/09/2018 - 03:50

for each interested party

User
23/09/2018 - 03:50

and i was hoping you could help me with a formula

User
23/09/2018 - 03:50

to put into OIP 1, 2, 3, 4, 5

User
23/09/2018 - 03:50

depending on the location that any one party may be interested in

Excelchat Expert
23/09/2018 - 03:50

am not sure with your requirement about sheet 1 data

Excelchat Expert
23/09/2018 - 03:51

What is your input to till the sheet1 ?

Excelchat Expert
23/09/2018 - 03:51

Based on your Party selection I need to fill the columns based on the values in Sheet 1 is it?

User
23/09/2018 - 03:52

well

User
23/09/2018 - 03:52

correct

User
23/09/2018 - 03:52

exactly that

Excelchat Expert
23/09/2018 - 03:52

Party 8 you have mentioned "P" but other columns there is a value

Excelchat Expert
23/09/2018 - 03:52

Which one is correct

Excelchat Expert
23/09/2018 - 03:52

*Sorry Party 7

User
23/09/2018 - 03:52

potentially both

User
23/09/2018 - 03:53

P would designate they haven't put forth site-level offers

Excelchat Expert
23/09/2018 - 03:53

Ok.. Let me check but its quite complicated one.

User
23/09/2018 - 03:53

i know...

User
23/09/2018 - 03:53

i generally think i'm pretty good at erxcel

User
23/09/2018 - 03:53

excel*

User
23/09/2018 - 03:53

but this is difficult

User
23/09/2018 - 03:53

was reading about an index match(false,isblank) formula

User
23/09/2018 - 03:53

but then i can't do second non-blank

User
23/09/2018 - 03:53

3rd, 4th, etc.

Excelchat Expert
23/09/2018 - 03:54

Ok.. just give me 5 minutes time

Excelchat Expert
23/09/2018 - 03:54

Request you to extend the time as well

User
23/09/2018 - 03:54

absolutely

User
23/09/2018 - 03:54

how.......

Excelchat Expert
23/09/2018 - 03:55

Can I include helper columns to get the result?

User
23/09/2018 - 03:56

on sheet 1 or sheet 2

Excelchat Expert
23/09/2018 - 03:56

Sheet1 ?

User
23/09/2018 - 03:57

let's start with yes

User
23/09/2018 - 03:57

and adjust later if it doesn't look okay?

User
23/09/2018 - 03:57

sheet 1 is the client deliverable...

User
23/09/2018 - 03:57

so i'm hesitant to include any non-relevant information

Excelchat Expert
23/09/2018 - 03:58

Ok.

User
23/09/2018 - 03:59

sorry but last change...

Excelchat Expert
23/09/2018 - 03:59

Yes tell me

User
23/09/2018 - 03:59

sheet 2

User
23/09/2018 - 03:59

added the column "current tenant want"

User
23/09/2018 - 04:00

if that reflects yes, OIP 1 in Sheet 1 should return "Current Tenant"

Excelchat Expert
23/09/2018 - 04:00

Sorry ! I didnt get you

User
23/09/2018 - 04:00

Sheet 2 Column E is tittled "Current Tenant Want?"

Excelchat Expert
23/09/2018 - 04:00

Yes

User
23/09/2018 - 04:00

If the column reflects "Yes"

Excelchat Expert
23/09/2018 - 04:01

*Row Reflects Yes

User
23/09/2018 - 04:01

exactly sorry

Excelchat Expert
23/09/2018 - 04:01

Ok.

User
23/09/2018 - 04:01

if the row reflects yes, OIP 1 on Sheet 1, should reflect "Current Tenant"

Excelchat Expert
23/09/2018 - 04:01

Ok.

User
23/09/2018 - 04:04

what are you thinking the solution might be?

Excelchat Expert
23/09/2018 - 04:04

No... It will be very difficult

Excelchat Expert
23/09/2018 - 04:04

Just give me sometime

User
23/09/2018 - 04:08

might i ask where you're located?

User
23/09/2018 - 04:08

would it be easier to discuss over the phone when you're ready?

Excelchat Expert
23/09/2018 - 04:08

Its not possible to discuss

Excelchat Expert
23/09/2018 - 04:09

Just give me a time

User
23/09/2018 - 04:09

wanted to step away from my desk but didn't want to miss your message

Excelchat Expert
23/09/2018 - 04:12

sure...

Excelchat Expert
23/09/2018 - 04:12

What do you mean by Total OIP

User
23/09/2018 - 04:12

OIP stands for "other interested parties"

Excelchat Expert
23/09/2018 - 04:12

I am asking in Sheet1 Column E

User
23/09/2018 - 04:13

total interested parties would be a more accurate column header

Excelchat Expert
23/09/2018 - 04:13

Sorry ! Thee is column called Total OIP in sheet 2

User
23/09/2018 - 04:14

just added the formula back

User
23/09/2018 - 04:14

that's just a count

Excelchat Expert
23/09/2018 - 04:14

Ok. Little bit confusion

Excelchat Expert
23/09/2018 - 04:15

In column F - I need to mention "Current Tanet" if its yes in Sheet2

Excelchat Expert
23/09/2018 - 04:15

What about other columns In Sheet1

User
23/09/2018 - 04:16

for example

Excelchat Expert
23/09/2018 - 04:17

Very confused

Excelchat Expert
23/09/2018 - 04:17

First you told "Party 7 " its there in B1 you want to pull Party 7 information

Excelchat Expert
23/09/2018 - 04:17

Where you got Party 11 , Party 14

User
23/09/2018 - 04:18

okay

User
23/09/2018 - 04:18

so

User
23/09/2018 - 04:18

let's say i need to generate sheet 1 for party 7

User
23/09/2018 - 04:18

party 7 is interested in two sites; they are offering to purchase both sites

User
23/09/2018 - 04:18

the first site that they're interested in is 12348

User
23/09/2018 - 04:19

the current tenant is interested in this site, in addition to parties 11, 14, and 20

Excelchat Expert
23/09/2018 - 04:19

Sorry ! its not at all possible

User
23/09/2018 - 04:20

do you recommend proceeding manually?

User
23/09/2018 - 04:20

or is there someone else that Got it can refer me to

Excelchat Expert
23/09/2018 - 04:20

its not at all possible to transfer

Excelchat Expert
23/09/2018 - 04:20

Just give sometime to think

Excelchat Expert
23/09/2018 - 04:22

you would like to pull party 6

Excelchat Expert
23/09/2018 - 04:22

you would like to pull party 7

Excelchat Expert
23/09/2018 - 04:22

but now you are saying need to get information about party 11 , 14,20?

User
23/09/2018 - 04:23

nope

User
23/09/2018 - 04:23

i need to pull party 7

User
23/09/2018 - 04:23

there are other parties interested in the same sites party 7 wants

User
23/09/2018 - 04:23

i need to identify those parties

Excelchat Expert
23/09/2018 - 04:24

then do you have 17 columns

Excelchat Expert
23/09/2018 - 04:24

but you have mentioned in the table OIP 1 to OIP 5

Excelchat Expert
23/09/2018 - 04:24

Its contacting with your table and output format

User
23/09/2018 - 04:25

don't need 17 columns

User
23/09/2018 - 04:25

maximum number of interested parties is 6

User
23/09/2018 - 04:25

would only need 6

User
23/09/2018 - 04:25

the property in row 10 of sheet 2

User
23/09/2018 - 04:25

has 6 interested parties

User
23/09/2018 - 04:26

that's the maximum

Excelchat Expert
23/09/2018 - 04:26

Oh.

Excelchat Expert
23/09/2018 - 04:28

no it is not at all posisble

Excelchat Expert
23/09/2018 - 04:29

This is the result as per your first requirement

[Uploaded an Excel file]

Excelchat Expert
23/09/2018 - 04:29

Otherwise your table sheet2 needs to change in different format

Excelchat Expert
23/09/2018 - 04:34

Are you there with me?

User
23/09/2018 - 04:34

yes hello

Excelchat Expert
23/09/2018 - 04:35

I am able to pull the information based on the party till column F

Excelchat Expert
23/09/2018 - 04:35

From Column G its not based on party it should be based on the property

User
23/09/2018 - 04:38

i'm not following

Excelchat Expert
23/09/2018 - 04:39

Ok! Really sorry for the inconvenience caused

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*