| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula to lookup table in another Worksheet please
Hello from Steved
=(D1-C1)*E1/4000 Ok I have A Table in a file named rulkilometre.xls It Has 2 columns Col A has B0101 Column B has 4000 The above formula also has a column with B0101. Ok the 4000 off the above formula may change from time to time, so I am asking what formula could I use please getting the 4000 from rulkilometre.xls worksheet. Thanks in advance. |
|
#2
|
|||
|
|||
|
Use VLOOKUP or INDEX&MATCH http://www.datapigtechnologies.com/f...s/vlookup.html http://www.datapigtechnologies.com/f...rixlookup.html Ola -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=378883 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Worksheet references another tab in formula | Excel Worksheet Functions | |||
| lookup or table, not sure what to do | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
