Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and return - NOOB question
I'm sure there's a simple answer for this, but I've searched for the better
part of 2 hours now and can't find what I'm looking for - any help will be greatly appreciated! Anyway, I have 2 sheets that contain customer names - one is a master list, the other new additions - I need to make sure there are no customers on the new addition sheet that already exist on the master sheet. Since the names may not be formatted the same, I used =LEFT to pull out a portion of each name on the new additions sheet. What I can't figure out is how to tell Excel to search the master sheet for the text in the additions sheet. Additions sheet: F 2 ADVANCED I Master sheet: A G 3580 123456 ADVANCED INDUSTRIAL SERVICES So on the additions sheet I need to find ADVANCED I within column G on the master and return the value for column A that corresponds to the name in G. Did I evplain that okay? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find replace text or symbol with carriage return | New Users to Excel | |||
Find $ in a string of text and return numbers | Excel Discussion (Misc queries) | |||
how do i use VLOOKUP to find text and return a number? | Excel Discussion (Misc queries) | |||
Find certain text in a column and return statement | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |