Hi I need some help on this table thing.
- I have 2 lists. Lets call them list a and list b on the same worksheet. I did a vlookup formula on the second worksheet to look up what was in a particular cell in list b in list a.
- This worked fine when I tried to find all the "harry" and "Diana" in the table as there are other names besides "Harry" and "Diana".
- However when it came to =vlookup(harry,list a,2,false) as there are many "Harry" and "Diana" with different figures, vlookup only took the first match for "Harry" and "Diana". And kept repeating itself.
- What I need it to Do is find all the "Harry" and "Diana" cells and information in column 2 from the first one onwards.