Jun 05 2023 06:07 PM
i thought this would be simple but - i don't know enough to make it work.
i have a simple "sheet 1" with information such as..
Name Amount Month Type
if name and month = values in "Sheet 2" i need the value of Amount.
thank you in advance for any help. if more information is needed i will make it available.
Tim
Jun 05 2023 11:14 PM
As far as I could understand...
To find the value of the Amount column in "Sheet 1" based on matching Name and Month values from "Sheet 2," you can use the VLOOKUP function in Excel. Here's how you can do it:
=VLOOKUP(A2,'Sheet 1'!$A$2:$D$100,2,FALSE)
The VLOOKUP function will search for the Name value in "Sheet 2" (in cell A2) within the specified range in "Sheet 1." If a match is found, it will return the corresponding value from the Amount column.
Make sure the Name column in "Sheet 2" matches the Name column in "Sheet 1," and the Month column in "Sheet 2" matches the Month column in "Sheet 1" for accurate results. Adjust the formula and ranges accordingly based on your actual data layout.
If it is not what you want, please add detailed information. How step by step (cell by cell) explanation if necessary a photo or file (without sensitive data). Information such as Excel version, operating system, storage medium, etc. would also help.