HI,
I have attached an excel file .I would like to run function VLOOKUP on that file.Here,How to look in A and C columns(name columns) and display the result in result coulmn starting from B coulumn)
HI,
I have attached an excel file .I would like to run function VLOOKUP on that file.Here,How to look in A and C columns(name columns) and display the result in result coulmn starting from B coulumn)
Enter formula in B9 and copy down
Formula:Please Login or Register to view this content.
or even this
Formula:Please Login or Register to view this content.
Last edited by AlKey; 01-19-2016 at 04:26 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This uses SUMPRODUCT instead. Enter in B9 and fill down
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks