egilliland
New Member
- Joined
- Jul 18, 2011
- Messages
- 3
I have a complicated situation that I am trying desperately to bridge. I have three spreadsheets, lets call them A, B, and C. I then have two more spreadsheets which are used to establish relationships between these spreadsheets, i.e. A-B and B-C. The problem is that A-B and B-C both use ID's to establish these relationships and I need to use actual item names.
What I am looking for is some sort of code I can use that can identify the ID and replace it with that row's title field from another spreadsheet. So In A-B where the spreadsheet looks something like...
ID A | ID B
----------
1 | 2
... I want it to replace the 1 with Apple, found on this spreadsheet...
ID | Name
----------
1 | Apple
I hope this makes sense - this thing is absolutely driving me nuts and this data needs to be input into a large website.
Thank you so much for your help!
Sincerely,
Eric G.
What I am looking for is some sort of code I can use that can identify the ID and replace it with that row's title field from another spreadsheet. So In A-B where the spreadsheet looks something like...
ID A | ID B
----------
1 | 2
... I want it to replace the 1 with Apple, found on this spreadsheet...
ID | Name
----------
1 | Apple
I hope this makes sense - this thing is absolutely driving me nuts and this data needs to be input into a large website.
Thank you so much for your help!
Sincerely,
Eric G.
