Hope this isn't too basic - please excuse me - I'm a newbie.
I have a table of tennis matchs played over a few days as follows:
date - player - rating - player - rating
30/3 A ?? B ?
29/3 C 10 F 5
28/3 B 25 G 10
27/3 D 15 A 10
26/3 C 30 B 5
25/3 A 20 F 15
First I need to 'lookup' player A's most recent game and enter it in the ?? space. So I need to check both columns to see if his most recent match was in the left or right column. In this instance it's in the right (ie: 27/3 which=10) but I don't want the entry at the 25/3 as it's an older game. Vlookup and hlookup allow me to search one column but not across two. Searching for player B's new rating has similar problems as there are games across two columns. This is also a continual process. On the 31/3 (ie:next day) I need to 'lookup' the next two player ratings by going over previous results
Thanks for any help you can provide - hope the above makes sense.