Formula problems
Hi guys,
This is my formula that already exists below, I have sheet and I added three more columns, and I have no ideia how to pull from those sheets.
For example In this sheet I have option ABC
I chosse option A, get will get a value from my other sheet.
I dont know how to chance it.
=IF(S14="x",0,IF(AB14="Local",VLOOKUP(A14,local,(IF($O14="x",3,2)),FALSE),IF(AC14="Ramp",VLOOKUP(A14,ramp,(IF($N14="x",3,2)),FALSE),VLOOKUP(B14,state,(IF($N14="x",5,3)),FALSE))))
Without seeing your workbook, it'd be nigh impossible to even guess at what your formula is calculating, what the named ranges pertain to, or what your new sheets are named.
Scroll down to Go Advanced, and then click Manage Attachments to browse to a sample of your work that you can share with us so we at least have a chance.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
HI
DRY REEFER
All Motor Rail All Motor Rail
What I am trying to do is pull the information from fuel bunker lookup..
To the Rate Analysis.But on the Rate Analysis it already exists a formula and I cant figure it out how to do it..
Go to Formulas, Name Manager. The named ranges 'local' 'state' 'ramp' pertain to ranges contained in the Fuel Bunker tab.
Which columns did you insert?
Did you inherit this workbook? It looks as if it's written by someone who's been using Lotus123. 1985 called and they want their =+ formula back.
Actually I have inserted 3 more columns on the a new sheet and I want to pull it from there.. which is called fuel bunker lookup...
When you look on the Dont Foward Rate Analysis, on the Mode part for example it shoes Motor/ Motor Rail I need to pull the amount from the fuel bunker sheet to the other one...
What data are you looking to get from the Fuel Bunker worksheet with your formula in AA14 of Don't Forward....?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks