SonicVoom

asked on

# Excel data linking between sprdsheets based on values

Hi!

I have one Excel 10 spreadsheet (SPRD1) with context specific values which are CPT codes (5-digit numeric). A have another sprd2 which contains tens of thousands of these CPT codes, with corresponding values called RVU.

What I would like to do is tell SPRD1 that when a specific CPT is used "12345", to go to SPRD2, find the row which contains "12345", and place the corresponding RVU in the assigned cell in SPRD1....

I have no idea how to do this... I've googled a fair amount and found similar questions, but the answers are very specific to the context and data that I've been unable to extract a formula....

Is that enough info to get me started? Thanks in advance!

I have one Excel 10 spreadsheet (SPRD1) with context specific values which are CPT codes (5-digit numeric). A have another sprd2 which contains tens of thousands of these CPT codes, with corresponding values called RVU.

What I would like to do is tell SPRD1 that when a specific CPT is used "12345", to go to SPRD2, find the row which contains "12345", and place the corresponding RVU in the assigned cell in SPRD1....

I have no idea how to do this... I've googled a fair amount and found similar questions, but the answers are very specific to the context and data that I've been unable to extract a formula....

Is that enough info to get me started? Thanks in advance!

ASKER

Wow, THANK YOU! I messed with it but I still I didn't get it to work (learned a small heap in the process though).

SPRD1 can now be called "Berry"

SPRD2 can now be called "pfr2006"

CPT in "pfr2006" is (now) in column A (it appears this is a must), and the corresponding RVU is in column I. This list is in numerical order.

CPT in "Berry" is in column E, and RVU is column P...The correspinding RVU from ["pfr2006", column I] is the value I want to add to ["berry", column P], based on the CPT used. This list is not in order.

I hope that a formula exists that can be placed down the column of a 150 page spreadsheet which would save having to go back and forth manually entering the RVU that goes with each CPT in "berry"... Possible?

SPRD1 can now be called "Berry"

SPRD2 can now be called "pfr2006"

CPT in "pfr2006" is (now) in column A (it appears this is a must), and the corresponding RVU is in column I. This list is in numerical order.

CPT in "Berry" is in column E, and RVU is column P...The correspinding RVU from ["pfr2006", column I] is the value I want to add to ["berry", column P], based on the CPT used. This list is not in order.

I hope that a formula exists that can be placed down the column of a 150 page spreadsheet which would save having to go back and forth manually entering the RVU that goes with each CPT in "berry"... Possible?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Not for points:

The vlookup does not HAVE to start in column A but the lookup value has to be in the leftmost column of the range. The offset is then the number of the column in the range.

So a range of A:I with an offset of 9 would return contents of column I, likewise a range of C:M for example with an offset of 9 would return contents of column K.

Thanks

Rob H

The vlookup does not HAVE to start in column A but the lookup value has to be in the leftmost column of the range. The offset is then the number of the column in the range.

So a range of A:I with an offset of 9 would return contents of column I, likewise a range of C:M for example with an offset of 9 would return contents of column K.

Thanks

Rob H

This article will help with VLOOKUP syntax: https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2637-Six-Reasons-Why-Your-VLOOKUP-or-HLOOKUP-Formula-Does-Not-Work.html

Not having a sample file I can only guess at your requirements, but assuming:

Then a formula like this should work:

=VLOOKUP(A2,SPRD2!A:B,2,FA