Explanding vlookup command to multiple cells

jimleslie77

New Member
Joined
Sep 27, 2006
Messages
5
when it use the command =VLOOKUP(B10,Sheet2!B3:C16,2,0) this works fine for the cell it is intended. but when i want to expand the command down by 20 cells (to b30) i need the B3:C16 part of the command to remain static instead of incrementing as i drag it down the list. Any Ideas. Thanks in advance. Jim
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

jimleslie77

New Member
Joined
Sep 27, 2006
Messages
5
Do i try this in the first cell then expand this down? instead of using my current command?

thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,109,541
Messages
5,529,437
Members
409,877
Latest member
DDhol
Top