Help with cross sheet formulas

steve50951

So i followed the steps. i checked to ensure data fields are consistent for the property wilson crossing.

here's the formula im using

=INDEX({CRS Vendor Setup Floor Plan Info}, MATCH($[Property Info]@row, {CRS Vendor Setup Property Name_}, 0), MATCH($[Floor Plan]@row, {CRS Vendor Setup Floor Plan Info}, 0) + 1)

im getting invalid value

obviously missing something...

Paul Newcome

{CRS Vendor Setup Floor Plan Info}

 

What is included within this range?

steve50951

yea. paul is helping me...ALOT i might add. Lol. thanks for checking in.

you guys are a great support.

steve50951

it is the range of columns that contains the floor plan info. floor plans, cost, etc...

Andrée Starå

Excellent!

We're always happy to help!

Kind regards,

Andrée

Paul Newcome

I am working out the bugs in this. When I figure it out I will post it at the bottom of the page since we are running out of room from side to side up here.

steve50951

Paul,

Sounds good.

I really do appreciate all of your efforts! This is gonna be a huge help for our company.

SGF

 

steve50951

Hey Paul,

Im just circling back around...Was wondering if you were able to make any progress on our Index/Match functions we've been trying to work through?

Thanks so much.

SGF

Paul Newcome

Not yet. I seem to have hit a wall. I haven't forgotten about this. It just happens to be providing more of a challenge than I initially expected. I'm working on it.

Paul Newcome

Apparently I just needed to take a short break away from it to look at it from a different perspective.

 

=INDEX({Master Sheet}, MATCH(Property@row, {Master Sheet Property Name}, 0), (MATCH([Floor Plan]@row, {Master Sheet}, 0) + 1) - MATCH(Property@row, {Master Sheet}, 0) + 1)

 

{Master Sheet}: Cross sheet reference that references every column from the Property Name all the way over to the very last Cost # column.

{Master Sheet Property Name}: Same as above except referencing only the Property Name column.

steve50951

Thanks. Yeah, no pressure. I have stuff im working on. Just on my list to cirlce back around too.

I really do appreciate your efforts.

SGF

steve50951

Ha! Sometimes that all you need. Ill plug it in.

Thanks Paul!

SGF

Paul Newcome

*Fingers crossed*

 

Let me know how it does...