Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it

I have a table like below
A B
1 x1234 value
2 y1234 value


If I want to look for all values that start with "x", is there a way to do it within a vlookup formula? Something like:

vlookup("x*", A1:B2, 2, False)

I know there's other ways to do this, but I want it all contained in one formula instead of splitting the A column using LEFT(A1, 1).

This is probably going to be an easy one for y'all, so thanks in advance.
I'm entering data in to column a, 8 digits.

I want the cell to return (the fixed string of characters+the 8 entered digits) in the same cell.

I believe I have seen it before, but I can't remember it off-hand.

I am creating a budget tracker that will have a couple of cells for miscillaneous spend. The information in these cells has to start z.1 Furniture, z.2 Racking etc.

I would like to allow people to specify what the item is by typing in the cell e.g. if i had a budget for cuddly toys i would want them to type into the cell Z.3 Cuddly Toy

What im trying to get round to saying is that is there a way that i can use data validation on a specific cell so that any information typed in that celll has z.x at the start.

Many thanks,

Chemist

Hi All

Can anyone help me with an excel formula which can prefix NSEI: to all symbols from Column A in Column B.
For eg - In Column A, first symbol is ABB
I want NSEI:ABB in Column B and like that for subsequent symbols in the list.

I am attaching the excel sheet containing symbols.

Is there any way out to PAD data in cells..?
For Example: I have text with various character lengths which I wish to unify using command similar to foxpro;s PadL() & PadR() like -
0123
222
33333
44
5

to look like this after left pading after making its length 5 with char "x"-
x0123
xx222
33333
xxx44
xxxx5

rgds, Jatins1408@gmail.com

Hi Guys
UDC 01_001 template black.jpg Batch 01_385 template white.jpg
UDC 01_001 template blue.jpg Batch 01_385 template blue.jpg
UDC 01_001 template grey.jpg Batch 01_385 template grey.jpg
UDC 01_001 template pink.jpg Batch 01_385 template pink.jpg
UDC 01_001 template white.jpg Batch 01_385 template black.jpg

I have 100s of urls with prefix as the left column. I need to rename them to the right column format. UDC 01_001 will take number Batch 01_385, UDC 01_002 will use Batch 01_386 and so on.

I cant figure out how to do this in one quick macro instead of replace function.

Any help will be greatly appreciated guys.

Thanks
Neil

Hi Mr. Excel Community,

I am working on a spreadsheet to track the results of manual software testing. Each spreadsheet contains many test cases, and each test case has a unique ID. The test case ID is used by formulas in the spreadsheet to generate statistical information. I would like to automate the generation of the test case ID to prevent problems with the statistics if a user forgets to enter the test case ID. Each ID has a prefix followed by a sequential number (e.g., BS-001). The prefix is the same for all test case IDs in a particular spreadsheet.

I want Excel to do the following:
1) Automatically generate a test case ID (D8), consisting of a prefix of any length and a 3 digit sufficx (i.e., 001 for D8) separated with a '-', when a user makes an entry in G8.
2) Prompt the user to input the prefix for the test case ID (i.e., "BS" from the example above), or use the prefix entered by the user in D8 for subsequent cells (e.g., D9, D10, D11, etc.).

In summary, I want Excel to automatically generate my test case IDs, using a user-defined prefix and standard three digit suffix, after a user makes an entry in an adjacent cell. The ID will look something like this for the first test case in a spreadsheet: "BS-001". Subsequent IDs would be BS-002, BS-003, etc.

Thank you in advance for any help you can lend.

Version: Excel 2000
OS: Windows XP Pro

I need to add one column into another..

i have a Column of numbers that all need to have a letter in front of them;
right now: 1, 10, 13, 14...etc
needs to be PS1, PS10, PS13, PS14..etc

The column does not go in numerical order so i cannot just drag the letter down. Is there a way to add these letter w/o having to copy and paste it into every row? Please help, i am trying to make a deadline!

I would like to import data from txt file into Excel file , the data in the
txt is prefixed with plus "+" , like +44-22, but the +44 never get into Excel
file .

Any way can make the +44 into Excel file

Thanks

Hi,

I have a list of of 12000 numbers in Column A,
And I have 350,000 numbers in Ms Access File.

Now I want to do a vlookup with Column A and Ms Access File.

Is this possible,

example:

I have 10000 rows in Column A and 350,000 Rows in Field 2 in Ms Access I want to check if those 10000 items are exists in There if any items exists then result should be "yes" if not "No" in excel.

I am not able to import the MS access data to excel because there are more than 300000 rows

Regards
Arvind