Hello -
I am trying to identify an alternative for the following IF/VLOOKUP formula
for 13 individual letters with matching Sheets!:
=IF(A3="A",vlookup(A!,A:H,6,FALSE),IF(A3="B",vlookup(B!,A:H,6,FALSE), etc.
Thank you in advance for your assistance.
Joe Stephens
|
|
0
|
|
|
|
Reply
|
 Utf
|
12/10/2009 3:21:57 AM |
|
>=IF(A3="A",vlookup(A!,A:H,6,FALSE),
You left out the actual lookup value.
Try it like this...
A1 being the lookup value.
A3 being the sheet name.
=VLOOKUP(A1,INDIRECT("'"&A3&"'!A:H"),6,0)
--
Biff
Microsoft Excel MVP
"Joe" <Joe@discussions.microsoft.com> wrote in message
news:8B69CB19-9D7C-4627-9053-2142C930E19C@microsoft.com...
> Hello -
>
> I am trying to identify an alternative for the following IF/VLOOKUP
> formula
> for 13 individual letters with matching Sheets!:
> =IF(A3="A",vlookup(A!,A:H,6,FALSE),IF(A3="B",vlookup(B!,A:H,6,FALSE), etc.
>
> Thank you in advance for your assistance.
>
> Joe Stephens
|
|
|
0
|
|
|
|
Reply
|
T
|
12/10/2009 4:00:34 AM
|
|
|
1 Replies
971 Views
(page loaded in 0.02 seconds)
Similiar Articles: IF/VLOOKUP between multiple worksheets - microsoft.public.excel ...Hello - I am trying to identify an alternative for the following IF/VLOOKUP formula for 13 individual letters with matching Sheets!: =IF(A3="A",... Vlookup in multiple sheets - microsoft.public.excel.worksheet ...IF/VLOOKUP between multiple worksheets - microsoft.public.excel ... Hello - I am trying to identify an alternative for the following IF/VLOOKUP formula for 13 individual ... VLookup Function over Multiple Worksheets - microsoft.public.excel ...I am trying to use the VLOOKUP function over multiple worksheets, can this be done on Excel 2003? I am trying to automatically retrieve data that... vlookup across multiple pages - microsoft.public.excel.worksheet ...IF/VLOOKUP between multiple worksheets - microsoft.public.excel ... Excel: Lookups across multiple sheets, vlookup, excel sheet vlookup, excel sheet, hth: if JULY is in D3 ... Adding VLOOKUPS across multiple worksheets - microsoft.public ...IF/VLOOKUP between multiple worksheets - microsoft.public.excel ... Adding VLOOKUPS across multiple worksheets - microsoft.public ... Hi, I am trying to add several ... Returning Multiple values from A Vlookup - microsoft.public.excel ...IF/VLOOKUP between multiple worksheets - microsoft.public.excel ... Returning Multiple values from A Vlookup - microsoft.public.excel ... IF/VLOOKUP between ... LookUP function with multiple variables and worksheets - microsoft ...IF/VLOOKUP between multiple worksheets - microsoft.public.excel ... I am trying to use the VLOOKUP function over multiple worksheets, can this be done on ... to look ... Multiple row comparison to sum potentially multiple values ...Sum Multiple Values With Vlookup - hi guys ... value in a table and ... row comparison to sum potentially multiple values ... Find unmatched rows between 2 worksheets ... V Lookup and Multiple Values - microsoft.public.excel.worksheet ...Hello, I am looking to figure out how to use V Lookup with multiple values. I have about 30 of the same name in column A (This is picked out of a... Using "Vlookup" across 2 Spreadsheets - microsoft.public ...IF/VLOOKUP between multiple worksheets - microsoft.public.excel ... Using "Vlookup" across 2 Spreadsheets - microsoft.public ... IF/VLOOKUP between multiple worksheets ... Use the Excel Vlookup Function across Multiple sheets - YouTubehttp://www.computergaga.com/excel/2007/intermediate/more_advanced_functions/v... Use the Excel Vlookup function across multiple sheets to retrieve a value ... IF/VLOOKUP between multiple worksheets - microsoft.public.excel ...Hello - I am trying to identify an alternative for the following IF/VLOOKUP formula for 13 individual letters with matching Sheets!: =IF(A3="A",... Vlookup. Excel Vlookup Across Excel Worksheets. Custom VLookup ...Vlookup in Excel to look across all sheets. Custom VBA Function to lookup across all Worksheets Excel - Vlookup Across Multiple Worksheets - Hi all I need ...Vlookup Across Multiple Worksheets - Hi all I need to execute a VLOOKUP across ten worksheets... - Free Excel Help Excel: Lookups across multiple sheets, vlookup, excel sheetvlookup, excel sheet, hth: if JULY is in D3, for example, use a formula ... Home; Computing/Technology; Business Software; Excel; Lookups across multiple sheets 7/27/2012 10:24:02 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
40 followers. 