Reply With Quoteuse this formula
=CONCATENATE($B$10," ",INDEX($E$5:$E$7,MATCH(A13,$D$5:$D$7,0)),INDEX($G$5:$G$7,MATCH(B13,$F$5:$F$7,0)),",",OFFSET($G$4,MATCH(B13,$F$5:$F$7,0),MATCH(C13,$H$4:$K$4,0)))
see the attached file
yes
no
OK people I have a problem.
A novice I am. I'm sure this is simple enough for most of you guys. Most of it has been comleted except one last part. I have drop down fields using a vlookup to grab the corresponding data in a colums next it which is being concatenated into a one big cell. The problem is a set of other columns that I need to pull data from but its dependant to a previous column. In the attachment you see which ever region is selected the following column data is grabbed and the same goe for title. Now when the location is selected the info in its column should be selected that corresponds to the row that the specific title is on. example
if selected: North America>Secretary>Texas
results: A Crazy Mix->;typical,Notepad, pen,square dance
I am sure you guys can figure this out.
Thanks
Long Term Member
use this formula
=CONCATENATE($B$10," ",INDEX($E$5:$E$7,MATCH(A13,$D$5:$D$7,0)),INDEX($G$5:$G$7,MATCH(B13,$F$5:$F$7,0)),",",OFFSET($G$4,MATCH(B13,$F$5:$F$7,0),MATCH(C13,$H$4:$K$4,0)))
see the attached file
Established Member
Administrator
Hi hapyhapy70
Welcome to ozgrid
Why the poll?
You guys are awesome! I would have never figured that out!
Thanks Thanks Thanks
I really did not mean to do a poll i just click on the box by mistake
Jedi
Lol...
Established Member
very even at the moment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks