Hi
Can I use a vlookup to look at a column but only drag across a specific piece of information i.e one persons name? instead of just lookup everything in the column? Thanks
Regards
Hi
Can I use a vlookup to look at a column but only drag across a specific piece of information i.e one persons name? instead of just lookup everything in the column? Thanks
Regards
I'm a bit confused with your description so I'm going more by your post title.
this will lookup a specific value in A2 and will stay locked on A2 regardless of if you drag the formula to the right...
=VLOOKUP($A$2,B:C,2,FALSE)
this will lookup a specific name that won't change if you drag the formula to the right...
=VLOOKUP("John Doe",A:B,2,FALSE)
this will look up a value locked in one cell and will look to the right as it is dragged right...
=VLOOKUP($A$2,$B:C,COLUMN(B$1),FALSE) and will index toward the right as you drag it but staying on column B.
are any of those what you are looking for?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi Sam
thanks for your help
Effectively I need the second option there but in reverse, have a column of Names which i need to match against a specific individual in another list. I.e of how many clients in the list the Sales person X meet.
could you follow the banner at the top and upload a workbook with a representative example and expected results so I know what you mean?
is what you are looking for an index/match but that you want to drag it to the right and have it move left?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks