HI
i have some problem with this
i have 4 sheets
i want to get data from those sheets according to my choice
i have drop-down list in C7
i want get value according to this drop-down list
VLOOKUP to A4
get value from sheets depnding on the drop-down
example
A4 = 1
if dropdown is GT#1 i want you find value 1 in that sheet and show it
if dropdown is GT#2 i want you find value 1 in that sheet and show it
if dropdown is GT#3 i want you find value 1 in that sheet and show it
etc...
thank you
i am using excel 2013
see the pic to help meassa.PNG
Bookmarks