Excel data linking between sprdsheets based on values
Posted on 2013-01-04
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!