Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using vlookup
I have a spreadsheet that was done by a former employee. it has five
worksheets. on it it uses vlookup. One of the cells has this formula in it. =IF($B42="","",VLOOKUP($B42,table,2,FALSE)) I cannot locate the table to make changes. How do I find out where the vlookup is pulling the information from? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using vlookup
Insert/ Name/ Define... will let you see which cells are defined by the
name "table". Alternatively the name box immediately above the top left-hand coner of your sheet (just to the left of the formula box) will let you type in "table", or select from the drop down arrow, and that will select the table. -- David Biddulph "sma" wrote in message ... I have a spreadsheet that was done by a former employee. it has five worksheets. on it it uses vlookup. One of the cells has this formula in it. =IF($B42="","",VLOOKUP($B42,table,2,FALSE)) I cannot locate the table to make changes. How do I find out where the vlookup is pulling the information from? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using vlookup
It's worth noting at this point that any named ranges which are of
automatically variable size will NOT show in the drop down list. Giz "David Biddulph" wrote: Insert/ Name/ Define... will let you see which cells are defined by the name "table". Alternatively the name box immediately above the top left-hand coner of your sheet (just to the left of the formula box) will let you type in "table", or select from the drop down arrow, and that will select the table. -- David Biddulph "sma" wrote in message ... I have a spreadsheet that was done by a former employee. it has five worksheets. on it it uses vlookup. One of the cells has this formula in it. =IF($B42="","",VLOOKUP($B42,table,2,FALSE)) I cannot locate the table to make changes. How do I find out where the vlookup is pulling the information from? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
using vlookup
Gizmo,
What do you mean by "automatically variable size"? Can you give me an example? AD "Gizmo63" wrote: It's worth noting at this point that any named ranges which are of automatically variable size will NOT show in the drop down list. Giz "David Biddulph" wrote: Insert/ Name/ Define... will let you see which cells are defined by the name "table". Alternatively the name box immediately above the top left-hand coner of your sheet (just to the left of the formula box) will let you type in "table", or select from the drop down arrow, and that will select the table. -- David Biddulph "sma" wrote in message ... I have a spreadsheet that was done by a former employee. it has five worksheets. on it it uses vlookup. One of the cells has this formula in it. =IF($B42="","",VLOOKUP($B42,table,2,FALSE)) I cannot locate the table to make changes. How do I find out where the vlookup is pulling the information from? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
using vlookup
Hi Arun,
Instead of defining a fixed area you can offset from a fixed starting point. E.g: =OFFSET(VizMiz!$C$4,1,0,COUNTA(VizMiz!$C:$C)-1,1) Assumes C4 as the fixed start, counts how many cells have data in column C, deducts 1 for the column header and then defines the table accordingly. In the run up to using this table I have a macro importing the data and removing any blank rows (essential!). This has to be setup through the 'Insert - Names - Define' menu. HTH Giz "Arun" wrote: Gizmo, What do you mean by "automatically variable size"? Can you give me an example? AD "Gizmo63" wrote: It's worth noting at this point that any named ranges which are of automatically variable size will NOT show in the drop down list. Giz "David Biddulph" wrote: Insert/ Name/ Define... will let you see which cells are defined by the name "table". Alternatively the name box immediately above the top left-hand coner of your sheet (just to the left of the formula box) will let you type in "table", or select from the drop down arrow, and that will select the table. -- David Biddulph "sma" wrote in message ... I have a spreadsheet that was done by a former employee. it has five worksheets. on it it uses vlookup. One of the cells has this formula in it. =IF($B42="","",VLOOKUP($B42,table,2,FALSE)) I cannot locate the table to make changes. How do I find out where the vlookup is pulling the information from? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
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 |