Lookup
Good Morning
I am having one of those days, all I want to do is lookup a value on sheet 1 column A and see if it appears in sheet 2 Column A and then in column B I want it to say is present or not present if it is or isn’t in the sheet 2
I have 1095 values in Column A sheet 1 and 705 values in column A in sheet 2
I want see what values from sheet 1 are not in sheet 2
Put this in B1 of Sheet1:
=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"not present","present")
then copy down.
Hope this helps.
Pete
Good morning
Perhaps using the countif function.
In B2 and copy down use this.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
thats perfect thanks.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks