Formula to search database and return data based on alphabet (NEED HELP)

[galbatrox9]

Hey.

I have this database with about 3,000 data which includes numeric and words.

Every Month i get each individual in my team gets alloted a range of numerics + letters, or just a range of letters. Sometimes the range is just like Jorge gets range L-S and sometimes its like Sam gets a range of Alie-De

Im trying to make a search option, where i can any random issuer name in a cell, and it pulls up the name of the individual it was Assigned to.

I have attached the excel sheet for your reference.

The red box in Sheet 1 is where i would like to type in the name from the Database sheet and, it would pull up the name of the guy assigned to it.

Can Vlookup do this?

[DannyJ]

VLOOKUP stands for vertical. I think you want HLOOKUP. I'm sure yo ucan guess what the H stands for!

=HLOOKUP(D12,Table1[#All],2)

Change the 2 for a 1 if you want to search the other way.

[llamafarmer]

Does the issuer list ever change?

[galbatrox9]

VLOOKUP stands for vertical. I think you want HLOOKUP. I'm sure yo ucan guess what the H stands for!

=HLOOKUP(D12,Table1[#All],2)

Change the 2 for a 1 if you want to search the other way.

Im not sure how this is going to bring the data out as per the Alphabetic range given for the person?



Can you edit my sheet and try it? If it works upload here so i can see please?

[galbatrox9]

Does the issuer list ever change?

It only increases. SO if a new issuer comes in, i just add it as a new row below.