Hi, I am trying to compare a cell that contains text located at "m87" with a
list of place names, ie Brisbane, Sydney, Melbourne.

Each city has numbers to go with it, so if the cell contains say Brisbane,
then it would input 30 into cell "n88". The same for the rest with diffrent
numbers of course.

I searched the forums for something similar, but no luck.

Any help appreciated.
Peter

Here's something that could work for you, its a VLOOKUP formul

+-------------------------------------------------------------------
|Filename: Vlookup.zip
|Download: http://www.excelforum.com/attachment.php?postid=4631
+-------------------------------------------------------------------

--
davesexce

-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=53292

$n n88
=if(m87="","",vlookup(m87,Sheet2!$A$1:$B$3,2,0))

assume on sheet2 in A1:B3:
Brisbane 30
Sydney 40
Melbourne 50

--
Regards,
Tom Ogilvy


"Peter" wrote:

Hi, I am trying to compare a cell that contains text located at "m87" with a
list of place names, ie Brisbane, Sydney, Melbourne.

Each city has numbers to go with it, so if the cell contains say Brisbane,
then it would input 30 into cell "n88". The same for the rest with diffrent
numbers of course.

I searched the forums for something similar, but no luck.

Any help appreciated.
Peter

Thanks to you both.
My mindset is still that everything has to be done in VBA, good to see it
can be done just as well in a formula =)
Now I have a new set of things to learn...this Vlookup thing looks
interesting.

Peter

"Tom Ogilvy" wrote:

$n n88
=if(m87="","",vlookup(m87,Sheet2!$A$1:$B$3,2,0))

assume on sheet2 in A1:B3:
Brisbane 30
Sydney 40
Melbourne 50

--
Regards,
Tom Ogilvy


"Peter" wrote:

Hi, I am trying to compare a cell that contains text located at "m87" with a
list of place names, ie Brisbane, Sydney, Melbourne.

Each city has numbers to go with it, so if the cell contains say Brisbane,
then it would input 30 into cell "n88". The same for the rest with diffrent
numbers of course.

I searched the forums for something similar, but no luck.

Any help appreciated.
Peter