Excel Auto fill based on criteriaClosed

Question

Hello,
I am looking for some help. I have a current excel worksheet that has: a1=tech name, b1=address, c1=zip. We have to manually look up the zip and then data enter into sheet, the tech number and address are copy and paste. Now here is the issue, I reassign all of my jobs so the tech numbers change in the billing system. How can I copy the tech number and address out of the billing system and have excel recognize the address column (b1) and auto fill the zip code. I have approximately 300 hundred entries. I am looking for a way to have my origianl (master) 1-300 and after reassigning 301-600 have excel recognize the address and auto fill the zip based on matching a record in the 1-300. All addresses will be an exact match?

Thanks in advance
Matt

Excelguru · Accepted Answer

use vlookup - VLOOKUP(lookup_value,table_array,col_index_num,FALSE)
dont for get to change the table_array fully locked

j · Answer

VLOOKUP?  INDEX & MATCH?  Seems to me that either of those might work for you

abdul · Answer

i thnk vlookup in this case
bt I need some thng to auto search a column a1 
if I write axy suppose it shows me all entries having axy at start or in begin
can u help?

rizvisa1 · Answer

Abdul, you can use match to use a wild card search. It will show you the row, You can use indirect to see the value if you so desire

Excel Auto fill based on criteria

4 responses

Similar discussions

Subscribe To Our Newsletter!