Forum Discussion
if function
I have two lists on the one worksheet- one for type of plant, and the other representing the rate for the different types of plant. On another sheet i want to be able to say that if - column c on w...
Thanks - i've taken a screen shot of both sheets. what i'd like to do is on sheet 1 - select the "plant used" from the list in column c on sheet 2 - and then put a function in the "rate" column on sheet 1 that pulls in the correct dollar value for that item of plant based on the answer you input to column c on sheet 1
Sheet 1
Sheet 2
I am very new to these types of functions, so any assistance would be very appreciated. Thank you for taking the time to respond.
InOrtap Clear! Firs, I would put the Plants and Rates in one table. Then depending on the Excel version you are on, use VLOOKUP or XLOOKUP to match the Plants in Sheet1 with the rates in the table from Sheet2.
You'll find an example in the attached file.
- Thank you so much for your help. I'll try this over the weekend! Cheers