Hi All,

I am trying to replicate the functionality of a vlookup in vba without using
loads of if statements.
For instance, imagine I have a list of people and there corrosponding ages
that I want to look up. I have an input box which asks for there name and I
am currently using application.worksheetfunction.vloookup to return their age
to a message box.

How can I avoid having the data typed into a range on the woorksheet without
doing a load of 'if name = john then age =35' type lines?

Any help would be gratefully appreciated.