I have two tables. I need to fill column T1B (table 1 column B) with values from column T2B if the value from T1A is equal with the value from T2A
Table 1 Column A Column B a1 a2 a5 a7 a9
Table 2 Column A Column B a1 b1 a2 b2 a3 b3 a4 b4 a5 b5 a6 b6 a7 b7 a8 b8 a9 b9 a10 b10
Any idea how I can do this?
Thank you.
Last edited by paul_aramis; 04-24-2013 at 10:50 PM.
hi paul_aramis, welcome to the forum. next time, do upload a sample excel file instead. assuming Table1 column A data starts in A2 & Table2 data in A10:B19, then:
=VLOOKUP(A2,$A$10:$B$19,2,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
Hi Paul and welcome to the forum,
This problem can be solved using the VLookup function. Read about it and see if you can make it work with your data.
see http://spreadsheets.about.com/od/exc...ss/vlookup.htm or
http://office.microsoft.com/en-us/ex...010069835.aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
thank you people. quick replay.
sorry, for the inconvenient. next time I'll upload the spreadsheet. actually the tables are in two different sheets.
I'll try. I'm not very professional with Excel, just an average guy who has to learn by himself, with help from peoples like you
ok, it worked. thanks again.
good night and good morning.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
oops, I'm back. sorry for multi-post.
it was easy with just Column A and B. but what if I'm using column C on table 1 and column B on table 2? example attached.
if I'm looking for data's on column D for column A, the formula it returns the correct value. formula is =VLOOKUP(A3;Foaie2!$A$3:$D$12;4;0)
but if I'm looking for data's on column B for column C, is not working. formula is =VLOOKUP(C3;Foaie2!$A$3:$D$12;2;0) and returns a value of #N/A
PS. sorry for the foreign word, I still have my office setup for old country language. "Foaie" means "sheet"
LE. I already used the reputation function, I'm familiar with this platform.
Try this instead. Under normal circumstances, vlookup cannot look "behind itself", meaning, it cannot search for anything to the left of the search column...
=INDEX(Foaie2!$A$2:$D$12,MATCH(Foaie1!$C3,Foaie2!$B$2:$B$12,0),MATCH(Foaie1!C$2,Foaie2!$A$2:$D$2,0))
OK Paul,
Here you go...
FDibbins, now it worked. I had to figure out where to change comma with semicolon, but is OK now.
Last edited by paul_aramis; 04-25-2013 at 12:16 AM.
Happy to help and thanks for the feedback
............................
Last edited by paul_aramis; 05-31-2013 at 06:21 AM.
Please start a new thread with this question. 1 thread - 1 question
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks