Vlookup with reference to another sheet

Mkaur

Hello,

I am trying to utilize VLOOKUP formula to return value from another sheet. Goal is to get Client Name from Sheet 2 into sheet 1. Below is the formula i am trying, however I keep getting error . When referencing the second sheet i can only select the task name column and not able to have the range from Task Name to Comments.

VLOOKUP(Task@row, {TEST01 Project ... Range 1}, 2, true)

Sheet 1

Sheet 2

VBAGuru

Vlookup is going to need a very specific data set and my guess would be that your range is not correct. Index/Match is more flexible overall, but does the same thing. You can have columns in any order this way.

=Index({TEST01 Project ... Range Comments},Match(Task@row,{TEST01 Project ... Range Task Name},0),1)

For you ranges:

{TEST01 Project ... Range Comments} = The Comments Column

{TEST01 Project ... Range Task Name} = The Task Name Column

This is then dynamic and you don't have to adjust it later.

VBAGuru

Vlookup is going to need a very specific data set and my guess would be that your range is not correct. Index/Match is more flexible overall, but does the same thing. You can have columns in any order this way.

=Index({TEST01 Project ... Range Comments},Match(Task@row,{TEST01 Project ... Range Task Name},0),1)

For you ranges:

{TEST01 Project ... Range Comments} = The Comments Column

{TEST01 Project ... Range Task Name} = The Task Name Column

This is then dynamic and you don't have to adjust it later.

Mkaur

@VBAGuru Thank you that worked !

VBAGuru

Glad that worked!

Have a great weekend!