Check cell against list and rename if not found

**bcarroll76** · 11-08-2018, 01:29 PM

Morning all,

I have a multi-sheet spreadsheet and I need to check cells in column A on sheet 1 against a list on sheet 2 (A2:A11). If the text in the cell does not find a match the list on Sheet 2, I want the cell to be renamed "Invalid User".

Thanks all!

**davesexcel** · 11-08-2018, 02:05 PM

Check it out.

Please Login or Register  to view this content.

**daboho** · 11-08-2018, 02:32 PM

Another option

Please Login or Register  to view this content.

**davesexcel** · 11-08-2018, 04:21 PM

Originally Posted by daboho

Another option

Please Login or Register  to view this content.

You need to be< 1 or =0 and it needs to start from A2

**daboho** · 11-09-2018, 01:06 AM

only small changed sorri last night not see workbook

Please Login or Register  to view this content.

Check cell against list and rename if not found

LinkBack

Thread Tools

Rate This Thread

Display

Check cell against list and rename if not found

Re: Check cell against list and rename if not found

Re: Check cell against list and rename if not found

Re: Check cell against list and rename if not found

Re: Check cell against list and rename if not found

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check Column for text then clear cell contents of cell if found

My File Rename Macro Always Doesn't Rename the Last Three files in the list

[SOLVED] Macro to rename cell content based on the starting character until found same character

[SOLVED] Check a cell for a list of data, if found then print row

Check for values in a table and if found add value found in column to left to list

[SOLVED] Check for dublicate data in a list, if found then substract earliest date from the latest

Check if cell value is found in a seperate range of values

Bookmarks

Bookmarks

Posting Permissions