VBA to chose format from one column & speed from different column

[dinkss]

Hi there,

I have excel sheet data created with VBA, and simple dropdown menu list to chose different formats.
But I would like to have an option to select format and then the line speed for selected format would show on cell on top of it.

Is there any VBA code that I could use or a simple dropdown menu list or macro? Can anyone help?

I have attached screenshots of my excel and formats with speeds.

Any help will be much appreciated.

 

[Fluff]

How about in C14

=VLOOKUP(C16,DATA_PULL!$A$3:$B$50,2,0)

 

[dinkss]

How about in C14

=VLOOKUP(C16,DATA_PULL!$A$3:$B$50,2,0)

Works great buddy.

Can you explain to me why you have entered this: $B$50,2,0 in the code? I presume it is only the range from A3 to B50 yes?

 

[Fluff]

That's right, in your image the range only goes down to row 25 so I added a few more rows for safety.

 

[dinkss]

How about in C14

=VLOOKUP(C16,DATA_PULL!$A$3:$B$50,2,0)

Your formula [=VLOOKUP(C16,DATA_PULL!$A$3:$B$50,2,0)] works fine but now I’m getting error with calculating data in cells:
Q10 = =SUM(C10:P10)
Q12 = =SUM(C12:P12)
Q14 = =IFERROR(AVERAGE(C14:P14),"")

How can I avoid getting errors and change formula to calculate SUM from C10:P10 in Q10 ?
How can I avoid getting errors and change formula to calculate SUM from C12:P12 in Q12 ?
How can I avoid getting errors and change formula to calculate AVERAGE from C14:P14 in Q14 ?

Before using VLOOKUP everything was fine but now, with vlookup option formulas are not working anymore

 

[Fluff]

How about

=IF(C16="","",VLOOKUP(C16,DATA_PULL!$A$3:$B$50,2,0))

 

[dinkss]

How about

=IF(C16="","",VLOOKUP(C16,DATA_PULL!$A$3:$B$50,2,0))

Now it works fine for Q14 cell, but it still gives errors for:
Q10 = =SUM(C10:P10)
Q12 = =SUM(C12:P12)

 

[Fluff]

What formula do you have in those rows?

 

[dinkss]

What formula do you have in those rows?

Q10 =SUM(C10:P10)
Q12 =SUM(C12:P12)

 

[Fluff]

I meant the formula that is return the #N/A