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 - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!
I am trying to pull from a sheet that is essentially a list of new records that are entered weekly. To keep things clean I have a helper sheet that just lists the project name once and the rest of the columns pull in through an INDEX/MATCH. I am trying to have that helper sheet pull in only the most recent entry. There is…
