Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Excel Function (Vlookup)

brillser, on Sunday 18 May 2008 à 12:33:14
Hello,



I need help with the vlookup functions in excel. Let's say I have two tabs, the second tab is a pivot table based on the first tab. I want to build a vlookup function (probably need two in the same formula) to pick up a field in a particular column based on the vlookup function. This should be a vlookup within a vlookup? Here’s what I want, in tab B (the pivot) lookup a value in tab A, then once it finds that number (there’s a list of the same number) then go back to tab B (select another field) then lookup on tab A again then return one of the field.
Kinda difficult to explain,

Assume that in tab A, I have
C B A X
1 2 4 X
F E D X

And in tab B, I have
A, B, C, D, E, F
1 2 3 4 5 6
The first lookup is, in Column A’s number lookup on column B, I know the return value is 100% true because the pivot is based on tab A. Then after that vlookup finish, then go to the next one, lookup Column D to tab A in column A. When both of those criteria hit, then return column X to tab B
Configuration: Windows XP
Internet Explorer 6.0
Reply to brillser  Report this message to moderators Go to last message

1


  • 1    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
georgiebest678, on Sunday 18 May 2008 à 13:29:08
Hai



I'm not sure if this is what you are looking for, but here goes...

=VLOOKUP(VLOOKUP(F1,Sheet1!A1:C10,3,0),A1:B10,2,0)

This formula, placed in Sheet2, will:

- Read the value in Sheet2!F1
- Lookup that value in Sheet1!A1:A10
- Return the corresponding value from Sheet1!C1:C10
- Lookup the returned value in Sheet2!A1:A10
- Return the corresponding value from Sheet2!B1:B10
   
Reply to georgiebest678

2


  • This message seems useful, vote!
  • Report this message to moderators
jackgopher, on Sunday 1 June 2008 à 19:53:55
Just wondering - did it work? I never tried a vlookup inside a vlookup.

http://www.microsoft-office-excel.com/function-vlookup.html
   
Reply to jackgopher

3


  • This message seems useful, vote!
  • Report this message to moderators
 midhun, on Tuesday 15 July 2008 à 07:08:22
sir,

I am requesting you to please give more information about HLookup.


Regards,

Midhun
   
Reply to midhun
Ask your question Reply

Résultats pour Excel Function (Vlookup)

Excel Custom Function Hello, i have created a custom excel function which works fine. the only problem being, you need to press F2 on the custom formula cell and give enter to refresh the formula. is there any way to refresh the formula every time the workbook is opened or... en.kioskea.net/forum/affich-24381-excel-custom-function
Download ArcSoft Print Creations Print Creation is as the name points it out, a helper of impression in any type. It understands the latest fashion of application of impression of ArcSoft' s with very so excellent functions.From the homepage, you will be able to achieve different... en.kioskea.net/telecharger/telecharger-584-arcsoft-print-creations
EXCEL Macro - Find and replace function -Help Hello, I work for a customer care ... I need to set a macro to delete customer information in the same file -- around 30,000 contact. I was thinking to use the find and replace function - but it does ONLY work for the original contact --- I can say... en.kioskea.net/forum/affich-24505-excel-macro-find-and-replace-function-help

Résultats pour Excel Function (Vlookup)

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf
Soople.com - All Google functionsoople.com - All Google function Soople is a website that offers all the functions of Google with a more simplified and attractive graphical interface(see below). It has been created for people who are not familiar with Google. This... en.kioskea.net/faq/sujet-380-soople-com-all-google-function
1 2 3 Next

Résultats pour Excel Function (Vlookup)

SUMIF or VLOOKUP? a range of cellsHi, I'm trying to perform a VLOOKUP or SUMIF on a range of data in another sheet. Eg sheet 1 is where i the formula is. Col C valuename ( formula) Sheet 2 has my data on, in the format:- A B C D E ValueName 2 4 2 2 2 I can obviously lookup... en.kioskea.net/forum/affich-3857-sumif-or-vlookup-a-range-of-cells
Excel Date Format (Solved)Hello, when users enter a date in excel using this format 12.1.2008, i need the cell to automatically change the format to 12-Jan-08 thanks, moses en.kioskea.net/forum/affich-19164-excel-date-format
Excel active cell macroHello, I'm trying to write a macro in excel which would copy and paste a range from WITHIN THE SAME ROW in the same sheet as the active cell is selected. For example let's say i select a cell within range A6:P36 then i would like the macro... en.kioskea.net/forum/affich-25813-excel-active-cell-macro
1 2 3 Next

Résultats pour Excel Function (Vlookup)

Download AO ReminderAO Reminder is the organizer par excellence. It is very practical and easy of use. Among these some main functionality: an option sound and alarms for you alert your important dates, an analogical clock, a calendar and the possibility of... en.kioskea.net/telecharger/telecharger-593-ao-reminder
Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer
Download ConnectCode Free Excel TrainingService Excel is an inevitable when they use Windows as Word is him. However her use is not of the most intuitive for the laymen. ConnectCode Free Excel Training is a program of study for introduction with Excel. It understands ten different... en.kioskea.net/telecharger/telecharger-568-connectcode-free-excel-training
1 2 3 Next

Résultats pour Excel Function (Vlookup)

Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3
Spreadsheet - Functions Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical functions that have analysis tools,... en.kioskea.net/tableur/tabfonc.php3
1 2 3 Next