Forum Discussion
VLookups
Hello, How would I create a vlookup to return information for more than one column? Example: I would like to look up the isbn # and have the author, title, college, class and cost show. ...
Hi LuCinda,
I am beginner of Excel. But i can solve it in my way.
For VLOOKUP function, i should have common values. One is where we get data from, where we want result in.
Assume that Table 1 is having data and in Table 2 we want our result. Here you want to VLOOKUP with 2 values (i.e) ISBN & AUTHOR.
Now, i do adding a temporary column with named as Temp1 in both Table1 & 2 and will combine values (use function concatenate) of ISBN & AUTHOR in Table1 & Table2.
Now both tables having a column that have combination of ISBN and AUTHOR.
Just do VLOOKUP based on these column. You will get result.
I have attached a sample file.
Thank you.
Is that works fine? Then mark this answer, if it feels best response for that.