If there is value in one column then a $ generates in another

Closed

KiwiJess Posts 1 Registration date Thursday June 6, 2013 Status Member Last seen June 6, 2013 - Jun 6, 2013 at 11:06 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 10, 2013 at 10:46 AM

Hi there,

I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. When someone selects the Long Hire in Column G I want it to populate with a rate in column H and when they select Single Hire I want it to populate with a different rate in column H.

Single Hire 40
Long Hire 120

Does anyone know the best way for me to achieve this please?

Cheers,
Jess

If there is value in one column then a $ generates in another
Display two columns in data validation list but return only one - Guide
Excel copy column from one sheet to another automatically - Guide
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
How to increment numbers when value changes in another column? - Excel Forum
Auto serial number in excel based on another column ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 10, 2013 at 10:46 AM

Hi KiwiJess,

Column H would contain:
=IF(G2="Single Hire",40,120)

Best regards,
Trowa

Similar discussions

Auto generate serial number in excel based on Column

Counting number of times a value appears if..

Converting rows of data in notepad to columns

VBA find column by name and sort

How to copy the Column value into Rows

Similar discussions

Subscribe To Our Newsletter!