Comparing Cell Value With A Reference
Hi Hans,
Not sure if I understand your question but it seems like it is for a
worthy cause!!! ;-)
If you have the following information in your Countries worksheet
Col A Col B
NED Netherlands < row 1
BRA Brazil
MEX Mexico
....
You get the drift. Then in your other sheet you can do a VLOOKUP
function to return the name of the country based on the abbreviation.
So for example if you have "NED" in Cell A1 you can use in A2 =
VLOOKUP(A1,Countries!A1:B32,2,0).
or in VBA wks.range("A2").formulaR1C1 =
"=VLOOKUP(RC[-1],Countries!$A$1:$B$32,2,0)", where wks is a reference
for the worksheet where you are working out your soccerpools.
Is this what you mean?!?
If this does not answer your question, please post more information in
relation to your query...
Regards,
Ric
|