Need help on multiple data entry

E

excellover

I have a multiple data combined of name and amount they make ,
e.g mike $200 , jerry $400 , ted $350 e.t.c a long list . what I wan
is when I enter say in cell A3 the name , cell B will turn the amoun
for that person . I tried to use the if syntax , but it is limited
while my list goes beyond 60 names.

Any help will be apperciated
 
M

Max

I have a multiple data combined of name and amount they make

Think you need to split the data first ..

Assuming the combined data is in
Sheet1, col A, A1 down, viz.:

mike $200
jerry $400
ted $350
etc

Select col A
Click Data > Text to columns
In step1: "Delimited" > Next
In step2: Check "Space" > Click Finish

In Sheet2
-------------
Names are listed in A3 down:

mike
jerry
etc

Put in B3:

=IF(ISNA(MATCH(TRIM(A3),Sheet1!A:A,0)),"",VLOOKUP(TRIM(A3),Sheet1!A:B,2,0))

Format B3 as currency
Copy B3 down

Col B will return the amounts
corresponding to the names in col A

Any unmatched names will return blanks: ""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top