Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup on Multiple Sheets
HI,
I think this may have been answered else where but I am having a hard time sifting through what is important so I will ask again. I have data in column a to g, in sheets 1 and 2. On sheet 3 I want to look up a value in "A " and match that value to a number in column "A" of sheet 1 or 2 (which ever sheet it appears in) and return the information contained in column "G". Is this possible and how do I go about doing this? Thanks!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup on Multiple Sheets
Here's one way:
=VLOOKUP(A1,IF(COUNTIF(Sheet1!A1:A5,A1),Sheet1!A1: G5,Sheet2!A1:G5),7,0) Biff "Excel_Oz" wrote in message ups.com... HI, I think this may have been answered else where but I am having a hard time sifting through what is important so I will ask again. I have data in column a to g, in sheets 1 and 2. On sheet 3 I want to look up a value in "A " and match that value to a number in column "A" of sheet 1 or 2 (which ever sheet it appears in) and return the information contained in column "G". Is this possible and how do I go about doing this? Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating data from multiple sheets. | Excel Discussion (Misc queries) | |||
Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
selecting multiple sheets | Excel Worksheet Functions | |||
Printing Multiple sheets | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions |