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 January 16, 2023 - 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
Generate unique id in excel ✓ - Excel Forum
Excel copy column from one sheet to another automatically - Guide
Display two columns in data validation list but return only one - Guide
Auto serial number in excel based on another column ✓ - Excel Forum
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

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Jun 10, 2013 at 10:46 AM

Hi KiwiJess,

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

Best regards,
Trowa

Similar discussions

Counting number of times a value appears if..

Increment cell value based on change in value of another cell

Auto generate serial number in excel based on Column

VBA find column by name and sort

Converting rows of data in notepad to columns

Similar discussions

Subscribe To Our Newsletter!