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. |
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. |
All times are GMT +1. The time now is 06:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com