| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup or find matching number in text string
I need help with a lookup function. I have an excel spreedsheet with 5
columns. , Clerk1, Clerk2....clerk5 The clerk fields contain text & numeric values (assignment codes). This is a general field where any text can be inputted with the numeric value. I need a formula to search all the columns, find a particular value (ie "15.06") and identify which clerk is working on that assignment. In this case, I would need the formula's value to equal "Clerk2" if I was looking up "15.06". The columns are not sorted & contain a variety/combination of text and numbers in each cell. All the numbers will have the decimal followed by two digits. Col A Col B Row1 Clerk1 Clerk2 Row2 12.07 for JS 63.07, 15.06 due TR Row3 899.07 & 701.07 for RO 229.07-231.07 row50 23.07 TR for RO 19.07 & 11.07 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find matching text | Excel Worksheet Functions | |||
| find last number in a string? | Excel Discussion (Misc queries) | |||
| Find Matching Text In Col A move to Col B | Excel Worksheet Functions | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| find position of a number in a string | Excel Worksheet Functions | |||
Threaded Mode
