Thread: linking data from two tabs.

I have two sheets. Both are ordered using different criteria, however I would like to link the records of one sheet to one of the fields in the second.

My thought was to use the match formula to pull the record number of one and then use that found number in an if statement on the other sheet.

e.g. =if(sheet1!A<supplied number from the match results>= "cookie", "eat, "don't eat")

Each line would evaluate the column and the variable from the match results.

I haven't figured out how to write this...is it even possible?

Is there a better way?

Thank you in advance!

signed,

humbled

Hi sirko,

welcome to the forum

If you use match, the result will be a number, but you 'd need an INDIRECT() to combine it into a cell address

=if(sheet1!A<supplied number from the match results>= "cookie", "eat, "don't eat")

=if(indirect("sheet1!A"&<supplied number from the match results>)= "cookie", "eat, "don't eat")

You may need a VLookup instead, something along the lines of

=if(Vlookup(Sheet1!a1,Sheet2!A1:B10,2,false)="cookie", "eat, "don't eat")

To give you a formula that better fits your data, you may want to upload a small data sample.

You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

hth