Sign in to join the conversation:
Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.
Yes it does.
If you post your formula, we might be able to tell you why it isn't working.
Are you getting an error message?
Craig
Here is my forumula:
=VLOOKUP(1, {2Testing_WFO (BO)_Master Sheet Range 1}, 2, false)
I am looking up the value of "1" in column A. If it finds "1" then return the value of the column B. The result I am getting is it display the correct value in B but it just repeats that value.
In the sheet I am referencing I have selected my range.
Thank you!
By 'repeating the value' do you mean you copy the formula to the rest of your column?
If so, the first argument (1) is what you are searching for. It will always find the same value from column B because you are always looking for the same thing.
You want to replace the 1 with something that is unique on each row (and needs to match in the source sheet)
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
