I can't remember how to do this - help appreciated.
I have codes that correspond to text in one table and I need to put the text that matches these codes into columns in another table.
Example attached.
In other words:
Identify match the codes in column C on the first tab with column C in the second tab
Then draw across the data from columns A and B in the second tab into columns D and E in the first tab
Can anyone help?
hi there, welcome to the forum. maybe this in D2
=INDEX('SIC Codes'!$B$2:$B$693,MATCH($C2,'SIC Codes'!$C$2:$C$693,0))
and in E2, change the front portion:
=INDEX('SIC Codes'!$A$2:$A$693,MATCH($C2,'SIC Codes'!$C$2:$C$693,0))
to counter errors, simply put an IFERROR:
=IFERROR(INDEX('SIC Codes'!$B$2:$B$693,MATCH($C2,'SIC Codes'!$C$2:$C$693,0)),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
In D2 and copy down.
=INDEX('SIC Codes'!$B$2:$B$2000,MATCH(C2,'SIC Codes'!$C$2:$C$2000,0))
In E2 and copy down.
=INDEX('SIC Codes'!$A$2:$A$2000,MATCH(C2,'SIC Codes'!$C$2:$C$2000,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
may be like this
to fill SIC Summary
=INDEX('SIC Codes'!$B$2:$B$693,MATCH('Base Data'!$C14,'SIC Codes'!$C$2:$C$693,0))
drag down
to fill SIC Description
=INDEX('SIC Codes'!$A$2:$A$693,MATCH('Base Data'!$C14,'SIC Codes'!$C$2:$C$693,0))
drag down
Thank you Ghozsi,Fotis,Benishiryo.
Just the ticket. Problem solved. I appreciate your help.
C
..................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks