Lookup Formula or Auto Select Options? I have successfully created Validation Da

Question

Lookup Formula or Auto Select Options?

I have successfully created Validation Data drop down boxes but feel these may be the wrong options for me.

My data is laid out as follows:

My actual table looks like this:

DROPDOWN MENU:
SELECT
5 TONNE TRUCK

53' TRAILER

DROPDOWN MENU:
$00.00
$56.00

=B5*B6

I need B5 to automatically select the correct amount rather than have to select it every time. How do I make B4 select data from my data table so that B5 auto selects the related cost for different truck rentals?

Please help !!

Thank you!!!

Explanation / Answer

Hi...

Hi,

B5 should not have a drop down. Try this formula in cell B5

=VLOOKUP(B4,$E$2:$F$4,2,0)

E2:F4 is where your data is laid out.

Hope this helps !!

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.