How to use VLOOKUP?



0

Hello sir,

I want to know if we can link more than one worksheet through vlookup.if yes how?
Also what i have understood is we can link only two worksheets of a same workbook.can we link two (or more )workbooks?
let me know at the earliest.thanks in advance.

3 Answer(s)


0

Yes you can link as many worksheets or workbooks at the same time to each other. There is no such restriction.

Like for example, sheet 1 could be linked to 10 different sheets in the same workbook and 10 different sheets in another workbook. You just have to link the normal way, open brackets, go to the specific worksheet, select the cell and complete the formula).

0

yes you can link more than one worksheet through VLOOKUP.

0

Yes you can link as many worksheets or workbooks at the same time to each other. There is no such restriction.

Like for example, sheet 1 could be linked to 10 different sheets in the same workbook and 10 different sheets in another workbook. You just have to link the normal way, open brackets, go to the specific worksheet, select the cell and complete the formula

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password