Charlize,

here is an example of what I am trying to do:

In the spreadsheet that I am testing:
345257
487585
120565
In the spreadsheet that I am looking up in
345257 Teddy I
487585
120565 Teddy I
This is what the original would look like:
345257
487585
120565

I tried to do it with a V-Look up and it didn't work.