Hi Guys
Can't seem to figure this out
In attached sheet3 ... I am looking for vba to populate cell C2 with a hlookup formula to give me the price of A2 from Supplier B2 found on sheet2...So that when the Supplier is changed - from drop down the price changes...Really stumped lol
Any ideas
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Formula would be something like:
=INDEX(Sheet2!$A$2:$I$3,MATCH(A2,Sheet2!$B$2:$B$3,0),MATCH(B2,Sheet2!$A$1:$I$1,0))
Rory
I had a similar idea to rorya using vlookup/match
Formula:
Please Login or Register to view this content.
You are a star ... tx rorya
You too... tx danielexcelvba
Hey guys...Help with adapting making use of lastrow in range...
Please Login or Register to view this content.
Since you mentioned you're doing this in vba, I'm guessing you're trying to fill up column C on sheet 3 with these formulas? If so, try something like
Please Login or Register to view this content.
rorya...I suck with formulas ... last question....
B2 is actually Range("B" & nr)
Can you incorporate pretty please ...
Could simplify using R1C1 references.Please Login or Register to view this content.
That's good guys...Solved...thanks a mill
Hey there guys...
Need to change this code to make use of ws2.name...
i.e Set ws2 = Sheets("Master Material") and replace
Edit...Please Login or Register to view this content.
All good now ... tx
Please Login or Register to view this content.
Last edited by sintek; 08-21-2018 at 01:55 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks