Forum Discussion
Need help on formula
Need help to do this formula A is ID and C is number and E is amount Want to find and calculate if I put a number in another cell then formula can find out which which ID have the number a...
You can use a combination of the INDEX and MATCH functions to achieve this.
Here's an example formula that you can use:
=INDEX(E:E,MATCH(G1,C:C,0))
In this example, G1 is the cell where you enter the number you want to look up.
The MATCH function searches for this number in column C and returns the row number where it is found.
The INDEX function then uses this row number to return the corresponding value from column E.
You can enter this formula in a cell and then copy it down to return the amount for multiple IDs.
Just make sure to replace G1 with the cell reference for the number you want to look up in each row.