Use indirect function to refer to a different worksheet

**boyboy400** · 07-11-2013, 05:57 PM

Hello everyone,
In the worksheet "trash" I have 6 cells with 6 numbers for example:

A B C D
1 1 2 3
2 1 5 3

In the worksheet "slice", I would like to compare these 6 values and see if they match or not.

=IF(AND(trash!B1=trash!B2,trash!C1=trash!C2,trash!D1=trash!D2),"bad","good")

This works fine!
However instead of having B1, B2, C1, C2, D1 and D2 in the formula I would like to get the numbers 1 and 2 from A cells. For instance:

=IF(AND(trash!INDIRECT("B"&A1)=trash!INDIRECT("B"&A2),......)

But this gives me error. Could you please correct this formula for me?
I really appreciate it.
Thanks

**martindwilson** · 07-11-2013, 06:02 PM

indirect for that is constructed like this
=INDIRECT("trash!b"&A1)

**FDibbins** · 07-11-2013, 06:06 PM

Hi and welcome to the forum

Try this...
=IF(AND(INDIRECT("trash!B"&A1)=INDIRECT("trash!B"&A2),......)

**boyboy400** · 07-11-2013, 08:07 PM

Thank you so much both of you. It works great

**FDibbins** · 07-11-2013, 08:20 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)