Vertical look up?

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Tue Mar 05, 2013 11:33 am

Vertical look up?

Postby APG1 » Tue Mar 05, 2013 12:07 pm


Is there a function in SPSS similar to Excel's "Vertical look up"?
(I am trying to match subjects' IDs in a column, with their code in another column in order to create a variable with their scores from a test, retrieved from a third column.)

Thank you in advance!
Ana Paula
Analyst Techy
Posts: 22
Joined: Mon Apr 27, 2009 2:19 am
Location: Melbourne, Australia

Re: Vertical look up?

Postby Analyst Techy » Thu May 02, 2013 1:00 am

Hi Ana Paula.

No there is no equivalent VLOOKUP in SPSS.

The best you can do within SPSS is Data>Merge Files>Add Variables.

Analyst Techy

Any solutions I provide on this forum are free of charge, donations go towards the maintenance of the unaffiliated SPSS forum.

Who is online

Users browsing this forum: No registered users and 2 guests