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.