ExcelBanter - View Single Post

Pete_UK

Thanks for feeding back.

Pete

LSB M wrote:
you're right, vlookup works perfectly.

I just happened to recall seeing a spreadsheet years ago with the case
function, which looked a but more elegant.

Thanks for your help!

:)

Pete_UK Wrote:
You could use a multiple IF statement, but it sounds as if VLOOKUP
would do what you want more precisely. Read Excel Help, and if it is
still not clear then post back with some more detail of what you want
to do.

Hope this helps.

Pete

--
LSB M
------------------------------------------------------------------------
LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258
View this thread: http://www.excelforum.com/showthread...hreadid=560518