vlook on different tabs based on value

J

jatman

good day,

i have the following so far in my macro:

....
supcode = Range("B4").Value
....
If supcode = "CLI" Then
ActiveCell.Offset(0, 4) = "=VLOOKUP(RC[-4], '[Order
Generator.xlsm]CLI'!C2:C4,2,FALSE)"
....

right now i have this code repeated several times for each supcode that may
exist and i am usingn an if statement for each possible "supcode". i would
like to replace all the if statements, and change the "CLI" to use the
"supcode" value.

how do i get the "supcode" value into the vlookup code?

thank you,

jat
 
L

Luke M

'All on one line
ActiveCell.Offset(0, 4) = "=VLOOKUP(RC[-4], '[Order Generator.xlsm]" &
supcode & "'!C2:C4,2,FALSE)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup on different sheet/tab based on stored variable 2
Consolidation Table from Different Excel Tabs with Different Format 1
Vlook-up in report with column Expansion 5
disable brian baulsom's worksheet change based on cell value. 2
Vlookup Different tabs based on Dates 5
The code below worked for a few days and just totally stoppedworking. 1
Can someone please tell me why my code stopped working??? 1
Using Field Codes with Automation 8

Top