looking for someone help finnishing a function

[frenchface]

Ok, lets see if i can explain this well. I am playing a game called tribalwars.net where you have a village that is on a coordinate system. I want to duplicate that coordinate system in excel. I have data that looks like this

ID X | y
1 502|343
.
.
.
4934 139|201
etc.

I have this function
=IF(IF(MATCH(J7,C:C,0)>0,HYPERLINK(M2,J7&"|"&K6))
this is what things are
where the second if is searching for the x and y coordinate

now the hyperlink is what i am stuck on; i know this part of the hyperlink is always that same
http://en34.tribalwars.net/staemme.php?village=92912&screen=place&mode=command&target=
now at the end there is an = sign. that = sign has to be sent the the ID number for the coordinates so for 139|201 it would be this
http://en34.tribalwars.net/staemme.php?village=92912&screen=place&mode=command&target=4934

now any idea how to do that in my forumla?

Thanks

 

[frenchface]

i quess a simpler question is, if i have two columns

a 1
b 2
c 3

how can i search for b and have it display 2?

 

[mikerickson]

The answer to the second question is the VLOOKUP function.