Index and Match - Referencing a different sheet

celento

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.  

J. Craig Williams

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

celento

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!

 

J. Craig Williams

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)

Craig