Conditional V-Lookup?

[engsnayl]

Hi Guys,

Little problem that I've not quite figured out.

Lets say I have a Sheet called "Data" which holds my source data...something like this in 3 Columns

Team PointsHome PointsAway

Atlanta 25 13
Buffalo 45 24
Cleveland 24 35
Dallas 13 39

So then in a 2nd sheet called "Fixtures" I want a to set up a V-Look up that will select and return certain values from my "Data" sheet like this...

(So in Fixtures)

HomeTeam PointsH AwayTeam PointsA

Atlanta 25 Dallas 39

To explain further, if in my Fixtures sheets I manually enter 'Atlanta' into a Column headed 'Home Team' then I want my formula to select and return the value of 25 from my "Data Sheet" and likewise if I manually type in Dallas into the column headed 'Away Team' then I want it to automatically return the value 39.

I hope that makes sense? Could anybody be kind enough to help?

Thanks

Stephen

 

[Aladin Akyurek]

In B2 of Fixtures enter:

=VLOOKUP(A2,Data!A:B,2,0)

In D2 of Fixtures enter:

=VLOOKUP(C2,Data!A:C,3,0)

 

[engsnayl]

Brilliant, thanks. Works perfectly.

 

[Aladin Akyurek]

Brilliant, thanks. Works perfectly.

You are welcome.