Matching two numeric values
Hi,
I have two sheets. I want to show in sheet 2 column B values in sheet 2 column A that match from column E sheet 1 and if they do not exist in sheet 1 column E then say do not exist and that cell in red colour. Sheet 1 Sheet 2 Column E Column A Column B 1233 4875 1355 5875 4875 1355 Thanks |
Matching two numeric values
Assuming there are no duplicate records in Sheet 1 Column E, a simple IF and
COUNTIF may do. Sheet 1 Sheet 2 Column E Column A Column B 1 1233 4875 =if(countif(Sht1!$E:$E,Sht2!A1)=0, "record not found",Sht2!A1) 2 1355 5875 (Copy the formula downward) 3 4875 1355 Hope this helps. tipoo wrote: Hi, I have two sheets. I want to show in sheet 2 column B values in sheet 2 column A that match from column E sheet 1 and if they do not exist in sheet 1 column E then say do not exist and that cell in red colour. Sheet 1 Sheet 2 Column E Column A Column B 1233 4875 1355 5875 4875 1355 Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200908/1 |
All times are GMT +1. The time now is 07:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com