Hi Mark,

Are you trying to do this via VBA or just a formula? If a formula is
sufficient you can just concatenate two VLOOKUPS. Try something like this:

=VLOOKUP("0022",A1:E19,2,FALSE)&" " &VLOOKUP("0022",A1:E19,3,FALSE)

This will leave a space between the two values (hence the " ").
If you wanted to do it programmatically, the same concept should work.