ExcelBanter - Vlookup for multiple worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup for multiple worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/212102-vlookup-multiple-worksheets.html)

BAKERSMAN

Vlookup for multiple worksheets

I need to do a vlookup on a specific range of cells. I need to look up values
from 2 separate pages within one worksheet. Is this possible?

smartin

Vlookup for multiple worksheets

BAKERSMAN wrote:
I need to do a vlookup on a specific range of cells. I need to look up values
from 2 separate pages within one worksheet. Is this possible?

VLOOKUP can only return one value, from one range, on one worksheet.
Would you describe your problem in more detail?

All times are GMT +1. The time now is 12:55 PM.