can this be done?

[Tartesos]

In sheet 2 I have a columm wiht all the ref. numbers from A1 to A10 (lest say). On that same sheet , but on columm B1:B10, there is a code number that is different for each ref. number on A1:A10.

In sheet 1 we have from A1:A10 where I can type a ref. number.

What Im looking for is a formula that will look on the sheet one and when you enter a number (A1:A10 sheet one) it will check that number and if it finds a 5 on the 9th place it will output the information from the B1:B10 of sheet 2 in the B1:B10 on sheet 1

So what I look for is the formula that will be able to check an entry number on A1 to A10 and if it finds the number 5 on the 9th place of that number it will get data from B1:B10 from the sheet 2 and put it on the B1:B10 on sheet 1. Is this possible??

Regards

 

[Oaktree]

Sounds like a job for a VLOOKUP. Have a look at VLOOKUP in Excel help.

 

[Tartesos]

I think that it needs more than just Vlookup.

 

[Scott Huish]

Can you post a sample of your data?

 

[Tartesos]

There is any kind of application i can use to post excel sheets here on the forum?

Regards

 

[Ganjin]

couldnt you do something like:
=IF(MID(A1,9,1)="5",vlookup(),"")

 

[Tartesos]

couldnt you do something like:
=IF(MID(A1,9,1)="5",vlookup(),"")

I will try this one. On the vlookup() I have to add the columns for the output data.. corret??

Thanks

 

[jasonb75]

Try posting a sample,

create a sample table for the Sheet2 data, apply "all borders" to the table, then simply copy it and paste into your reply here.

Then do the same for Sheet1, with a few examples of what you will be entering in column A and the result you would expect in column B.