Can anyone help with a formula in my spreadsheet?
In the daily's tab in column F is an imei number, I want Column I in Stock to say Yes if that imei number appears ANYWHERE in the stock tab or no if it doesn't.
The formula I have entered puts a yes in the column if for example in daily's F2 is the same as Stock F2, but not if Daily's F2 is the same as Stock F3!!
Hope I'm making sense!
Can anyone help?!
Hello NicciB,
Please change the title of your post to reflect your question. This will help other forum members to help you. Please take some time to read the forum rules, so you can get the most benefit from being a member. Click the link below...
Forum Rules
Sincerely,
Leith Ross
Hi NicciB.
Please remember to use a title that is more descriptive of your question/problem. See the forum rules.
Forum Rules
Try in Stock column I,
=IF(ISNA(MATCH(B2,'Daily''s'!F:F,0)),"No","Yes")
Copy down as needed.
HTH,
SteveG
Last edited by Simon Lloyd; 06-04-2008 at 03:58 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks