excel lookups

I am in need of a formula which will search for a specific value in a column of cells that may contain more than one value in each cell. e.g. A B C D E F 1 ROLE RESULT ROLE RESULT 2 897 BONUS 563, 897 BONUS 3 167 #N/A 4 897 BONUS 5 637, 598, 897 BONUS 6...

Hi, I am an excel noob and I am having trouble explaining this through text haha, so sorry if this is simple. I have cleaned (deleted hundreds of rows of useless data) information on an excel sheet and fixed names etc, I have then unfortunately deleted an important column. Due to the amount of...

We need to update 1000's of record (which are in a excel file) wherein which the first column has the Unique ID's. The problem is Unique ID is duplicated. This is how my file will look like. "Sample - ID" (Column C) is unique and it's duplicated. But one set of sample id will have values in...

I have data in column A and B have lookup data. If the any of the lookup data is partially matching in the result column need to put lookup data. I tried with VLOOKUP but no luck. Please help me. Columns: A B(Lookup)...

I have a formula that is giving me a #value error. I am trying to match the value in Sheet1!B2 to Sheet2|ColumnB I have tried different combinations with no luck. The value I am looking for is in Sheet2!B94. =VLOOKUP(TRIM(Sheet1!B2)|TRIM(Sheet2!A1:B94)|2|FALSE)

I have to translate a list of old client & matter numbers to new client and matter numbers. Client and matter are related parent child, so for each client there can be many matters. And, matters can be the same for each client. For instance, below lists the old client and matter numbers along...

I have my excel data like this in a workbook named :Customer_Information I was looking for a formula that able to allow me to auto retrieve the rest of the detail when specific data is being insert. Here will be my data inside my workbook, Customer_Information: This will be the data in...

Dear All, I have a data excel, I need a formula which will do a lookup in column A (sheet 2) to find the names which doesn’t exist in column A (sheet 1) if found it placed that name into column A (sheet 1). For example: Sheet 1 Sheet 2 <tbody> Column A...