|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
12-04-2007, 07:52 AM
|
|||
|
|||
|
Variation of Vlookup?
Hi
This might sound fairly simple to most guys there but im stuck with it and in a hurry so havent been able to search the posts much. The problem is as follows. I have two tables with say 3 fields in each in columns A,B,C and G,H,I. Now i want to look every value in column B in column G and if a match found, replace content of column C with value from column I corresponding to the value of G which has been matched. I am not sure if i have been too clear so ill try giving an example A B C G H I 1 aa pqr aa 3 lmn 2 bb stu bb 4 pqr 3 bb hij cc 5 xyz 4 cc def dd 6 aaa Output A B C 1 aa lmn 2 bb pqr 3 bb pqr 4 cc xyz It looks simple i know. I tried variations of vlookup and If loop but havent managed it. I know i must be missing something. Dont know what. Guys/Gals help is appreciated Regards Pradeep 
|
|
#2
12-04-2007, 08:48 AM
|
||||
|
||||
|
you tried?
=Vlookup(B1,G:I,3,0) copied down.... where B1 is first item to lookup
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
