VLookups

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.

The only way that I know to do what you are looking to do is to concatenate vlookup formulas together, one for each column oif data that you are looking to pull in.