# Alpha numeric lookup and sum

#### bibbyd01

##### Board Regular
Hi All

I have another tricky puzzle I'm trying to solve (or tricky for me anyways).

I have a workbook with about 30 sheets. The first sheet has a list of customer numbers in the first column. All other columns in this sheet use the vlookup to pull data from the other sheets of the workbook.

In the first columns, there are three types of data, numeric, alpha, and alpha numeric. The column is sorted into an ascending order. for example;

23
45
58
1A
C1
E1
ON
X3

All of the numeric values can have a lookup individually, but I need to write something that allows me to total 1A and ON together, and total everything that is alpha numeric together so they all appear on the same line. It's a little beyond my VB coding skills at the moment! I can send an example spreadsheet with the existing code if anyone thinks they can help?

Also, I'm using Excel 2003

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
Does the SUMIF function not work for you?

Replies
6
Views
311
Replies
7
Views
226
Replies
1
Views
306
Replies
11
Views
2K
Replies
3
Views
553

1,202,987
Messages
6,052,932
Members
444,616
Latest member
novit19089

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back