Originally Posted by
christianbber
I'm trying to pull data from spreadsheet 2 into spreadsheet 1.
Spreadsheet 1 has names in this order,
John
Sara
Katie
Spreadsheet 2 has data of,
John REG 80
HPI $86.75
FED $16.76
State $24.54
Sara REG 36
HPI $45.75
FED $56.76
State $98.54
Katie REG 14
HPI $67.75
FED $56.76
State $98.54
I know how to use Vlookup but what I dont know is how to specificy which values to pull into spreadsheet one once Vlookup has found the identical value.
More specifically, all I need is the HPI #'s which is in a different column and row .
What I'm trying to get is a command (script?) that says Look at name "Sara", find Sara in the column next to it. Then pull the data thats in column X, row Y.
However, after I'm done with Sara, the next name will have a different column and row # to which I need the data pulled......
Any help is appreciated.
Thank you.
Bookmarks