Find value in a range, then use value in adyacent cell

[Iolao]

I'm trying to build a league table for soccer and I have a problem i
having all automatic. My goal is that league stats should update a
soon as I insert results in the "matches od the day" table. I'l
explain my table:

A,B,C,D
Team1,3,0,Team2
Team3,1,0,Team4
Team5,0,0,Team6


I need a formula to find the team in the column A (only one column a
time as I have tables for home and away games), and IF it finds it
THEN it should read the value in the SAME row but in adyacent column (
or C for example), IF not tha it should leave blank. I tried:

=FIND(B1:B3; A1:A3)

but I don't know why it works randomly, with some cells that displa
#N/D and others working.... is it because of me trying to find text

 

[Ron Rosenfeld]

I'm trying to build a league table for soccer and I have a problem in
having all automatic. My goal is that league stats should update as
soon as I insert results in the "matches od the day" table. I'll
explain my table:

A,B,C,D
Team1,3,0,Team2
Team3,1,0,Team4
Team5,0,0,Team6


I need a formula to find the team in the column A (only one column at
time as I have tables for home and away games), and IF it finds it,
THEN it should read the value in the SAME row but in adyacent column (B
or C for example), IF not tha it should leave blank. I tried:

=FIND(B1:B3; A1:A3)

but I don't know why it works randomly, with some cells that display
#N/D and others working.... is it because of me trying to find text?

Look at the VLOOKUP function. Set it up for exact matches and test for NA
results.


--ron