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)
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
