Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
does anyone know if you can vlookup to multiple tabs. I have a list of
products (262 items) and 1700 stores. I would like to put all this info into excel but as you can 262 x 1700 stores would be too big for one tab. So I would like to put into mulitple tabs. I would like to make a summary tab with a vlookup that would summarize info for 1 product. So, can you vlookup in multible tabs? Thanks for any help, B. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
=IF(ISNA(VLOOKUP(A1,range1,2,FALSE)),VLOOKUP(A1,ra nge2,2,FALSE),VLOOKUP(A1,range1,2,FALSE))
Replace A1 and the RangeNames according to your data. Vaya con Dios, Chuck, CABGx3 "BSantos" wrote: does anyone know if you can vlookup to multiple tabs. I have a list of products (262 items) and 1700 stores. I would like to put all this info into excel but as you can 262 x 1700 stores would be too big for one tab. So I would like to put into mulitple tabs. I would like to make a summary tab with a vlookup that would summarize info for 1 product. So, can you vlookup in multible tabs? Thanks for any help, B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |