ExcelBanter - Using worksheet code name in this code

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using worksheet code name in this code (https://www.excelbanter.com/excel-programming/369898-using-worksheet-code-name-code.html)

Barb Reinhardt

Using worksheet code name in this code

I'm trying to use a worksheet code name in this code

"=VLOOKUP(RC3,Sheet1!NamedRange,2,FALSE)&""-""&'Sheet2'!RC4"

I have a code name for Sheet2 that I want to add to this. Can someone
assist us? We are so far having no success.

Thanks

Jim Thomlinson

Using worksheet code name in this code

As a guess...

"=VLOOKUP(RC3,Sheet1!NamedRange,2,FALSE)&""-""&'" & Sheet2.Name & "'!RC4"

--
HTH...

Jim Thomlinson

"Barb Reinhardt" wrote:

I'm trying to use a worksheet code name in this code

"=VLOOKUP(RC3,Sheet1!NamedRange,2,FALSE)&""-""&'Sheet2'!RC4"

I have a code name for Sheet2 that I want to add to this. Can someone
assist us? We are so far having no success.

Thanks

All times are GMT +1. The time now is 10:25 AM.