Forum Discussion

Evelyn Conde's avatar
Evelyn Conde
Copper Contributor
Jun 22, 2018

Beginner in Excel need with help matching formula

Hi I need help find a formula that looks at 2 worksheets to see if the data matches...if so enter result here

example:

look for this ## in column A (from sheet 1)...in columns a-g in sheet 2 if TRUE return the value in column A from sheet 1???

 

 

 

   

  • Quick question: how is sheet2 made?

     

    If there is no particular structure, you can just use a COUNTIF(sheet2!A:G;valorinsheet1) into an IF condition:

     

    This can be in sheet 1:

    IF(COUNTIF(sheet2!A:G;valorinsheet1)>0;valorinsheet1;"no such valor")

    This counts how many times there is the valorinsheet1 valor in sheet2 column A to G. If there is no such valor, the result is 0, so the IF gives you "no such valor" (you can use also 0, "" to leave the cell empty, or whatever other content you want to insert in case you don't find the value).

     

    If you have to look for that value in a certain ROW and in columns A to G, then is different and it needs more work.

Resources