How do I locate a point of intersection between two lines on Excel?

This solution is to use goal seek

1. set up a table with the following headers

Cell A1 put x,

B1 put y

C1 put x - y +2 =0 (equiv. of y = x + 2)

D1 put 2x-y+1=0 (equiv. of y = 2x + 1)

2. make excel equivalent formula for the 2 equations

C2 put =A2-B2+2

D2 put =2*A2-B2+1

E2 put =C2+D2

at this point C2 has 2 and D2 has 1 cause A2, B2 is blank/0, E2 is to ensure both formula is 0, but now is 3

3. select E2, go to data ribbon, solver,

set target cell, $E$2

equal to value of 0

by changing $A$2:$B$2

click add button

Make $C$2 = 0 and $D$2 = 0

click solve

Then A2, B2 will be filled with x, y, when C2, D2 and E2=0 which is the result.