I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to check the box.
Is there data on each sheet that is unique to each row?
yes. each row has a property name that is unique to that row.
Ok. Try something like this...
=INDEX({Other Sheet Checkbox Column}, MATCH([Property Name Column]@row, {Other Sheet Property Name Column}, 0))
works great!!! Thanks!
SGF
Happy to help! 👍️
so invoice department added and additional column to index and match. They want to pull the "3rd Party Vendor" i copied the formula above and selected the column for the range, but its not quite returning the right info.
Here is the formula i am working with
=INDEX({CRS Vendor Setup Prop Name}, MATCH([Property Info]@row, {CRS Vendor Setup Vendor}))
But its returning the a value from the row above it. "Lumiere Chandler" instead of returning the value i want..."OPS"
Im missing something simple. Would you mind looking at it one more time?
Thanks
Try searching for an EXACT match with a zero at the end of your MATCH function....
=INDEX({CRS Vendor Setup Prop Name}, MATCH([Property Info]@row, {CRS Vendor Setup Vendor}, 0))
comes back with a "No Match"
Is that exact text within the range on the source sheet?
i need it return the value in the cell in the column "3rd Party Vendor Name" corresponding with "Madison at Round Grove" The value i need it to return is "OPS"
Am i using the wrong type of formula?
Yes. I understand what you need. I am just trying to help troubleshoot.
Try just the MATCH function.
=MATCH([Property Info]@row, {CRS Vendor Setup Vendor}, 0)
What happens?
still returns a NO MATCH...hmm
i figured it out.
=INDEX({CRS Vendor Setup Vendor Name}, MATCH([Property Info]@row, {CRS Vendor Setup Prop Name}, 0))
swapped the range values in the index and match.
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?