Forum Discussion
if function
InOrtap In the "other" sheet, use a lookup function (INDEX/MATCH, VLOOKUP or XLOOKUP) to find the correct amount for the different types.
Perhaps you can share the file you are working on or at least insert som clear screenshots showing the layout of relevant parts of both sheets.
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