Formula question

[RAVIRAJA36]

Hi Friends,

Here attached my file i need to to following things in macro using code.Please help me to get result.
Step:1
Model number in Sheet3-output(col:C) has been split-ed Column D2 onwards.(According to Sheet2-input(Col:E) structure used MID formula).
Step:2
Now have to do vlook up:
Lookup value=Sheet3-output.("C2:C5")
Look up range=Sheet2-input.("E2:AG99")
Values Return column index from 2 to 29

Ex:C2=EJA110E_1 Sheet2-input-column C2:C99)
Vlook up Result of above = TRANSMITTER (Sheet3-output-Col:D2:D9)

Please help me on this & need urgently.....I have done in excel & struggling to do in macro.

I'm waiting for ur help friends and thanks in advance...

Regards,
Raviraj

 

[NARAYANK991]

Hi ,

Please clarify what exactly you need the code to do. Which cells will have the input data on the tab Sheet3-output , and which cells will the code have to populate ?

Please do not expect anything urgently.

Narayan

 

[RAVIRAJA36]

Hi Friend,
Thanks for your reply.
Cell C2 to C9 have a input on the tab Sheet3-output
and lookup range is on the tab Sheet2-input (E2:AG99) & all the values to be populated one by one based on lookup values on tab Sheet3-output Cells:D2,E2,....AE2

Regards,
Raviraj

 

[RAVIRAJA36]

Ex:Input:EJA110EDFSJ0710EB. on tab Sheet3-output;Cell C2
To split input like this.
EJA110E_1 (here 1 is char.position number from start E to End E)
and EJA110E_8_D (here 8 is char.position number(Char.D)
and EJA110E_9_F (here 9 is char.position number(Char.F)
and EJA110E_10_S (here 10 is char.position number(Char.S)
and EJA110E_11_J (here 11 is char.position number(Char.J)
and EJA110E_12_0 (here 12 is char.position number(Char.0)
and EJA110E_13_7 (here 13 is char.position number(Char.7)
and EJA110E_14_1 (here 14 is char.position number(Char.1)
and EJA110E_15_0 (here 15 is char.position number(Char.0)
and EJA110E_16_E (here 16 is char.position number(Char.E)
and EJA110E_17_B (here 17 is char.position number(Char.B)
Now we can compare splitted ouput with tab Sheet2-input Cell:E2.both are similar
ExEJA110E_9_F(D2-Sheet3-output)=EJA110E_1(E8-Sheet2-input).
both sheets have common value to do vlookup now(tab: Sheet2-input Cells(E2:E99) & tab Sheet3-output).

Please let me know if need more info

Regards,
Raviraj

 

[RAVIRAJA36]

Hi Narayan,

Any idea do u have on this...

Raviraj.