Forum Discussion
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 TRU...
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.