I am trying to get the MSRP (P5 on sheet “XR1”) of MFG PART # CRB-XR1-D1001 (C5 on sheet “XR1”) from I550 on sheet “Price List Working” by making some type of formula.
You can download the file from here... www.xlevelonline.com/junk/Cobalt.xls
Can anyone help me out?
Sorry for not coming up with a better title for this thread. If a mod feels there is a better title, feel free to change it. I'm a total noob at this and other than the Video Professor CD's, I'm self taught.
Have you tried VLOOKUP?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I just read the help section on VLOOKUP but, I don't understand how it works or even if it works from sheet to sheet.
Actually, =VLOOKUP(C5,B4:N617,8,FALSE) , would work if I change all the XR1's in column C on sheet "XR1" to XXX and tell it that B4:N617 references sheet "Price List Working." Right?
Last edited by XLevel; 11-09-2007 at 04:07 PM.
Wow, I can't believe I just figured this out! Thanks for pointing me in the right direction, Roy. I'm usually pretty decent at figuring it out if I know the direction to go and it's actually better to learn it instead of just having it handed to you. Thanks again.
This is the formula I used:
=VLOOKUP(C5,'[SHEET1]Price List Working'!B4:N617,8,FALSE)
BUT, (there's always a but) that leads me to my next problem. Some parts reference a newer part like row 11 on sheet "Price List Working." In the "reference" column (column F) it says to use a different part number. In this case it would be CRB-XXX-D30 as D30 is displayed in F11.
How would I make it recognize there is no value in column 8 as shown in the above formula and then substitute D30 for the D21 in B11 (value CRB-XXX-D21) it was looking for?
Last edited by XLevel; 11-09-2007 at 04:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks