Use cell value as array name in formula

Closed

Jessica_ful - May 27, 2010 at 03:03 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 03:41 PM

Hello,

I'd like to perform a lookup with a variable array name based upon another cell's value without VB code. Does anyone have a suggestion?

Ex: =if(isblank(B4),"",Lookup(A4,arrayname)), where array name is set by B4.value

Many thanks,
Jessica

Use cell value as array name in formula
Date formula in excel dd/mm/yyyy - Guide
Vba check if value is in array - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Position formula in excel - Office Software Forum
Number to words in excel formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 27, 2010 at 03:41 PM

Seem like you may have to use ADDRESS or INDIRECT or a combo

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

If a cell contains any text then add a value

help me to add particular cells

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!