| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use "VLOOKUP" with different Table Arrays
I have tried using "VLOOKUP" but I have a problem getting values from more
than one table array For example, In one cell I want information from "Equipment" but in another cell I want information from "Employee" but instead only receive #NAME? Please any help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use "VLOOKUP" with different Table Arrays
Do you have one column of cells, where you want it to sometimes return
the value from the array "Equipment", and sometimes return the value from the array "Employee"? Or do you mean that you have two different columns, two separate VLOOKUP formulas, and one of them is not working? It might also help if you post the specific formula(s) you're using. Thanks, Rachel Garrett On Jun 19, 9:00*am, gnarvaez3 wrote: I have tried using "VLOOKUP" but I have a problem getting values from more than one table array For example, In one cell I want information from "Equipment" but in another cell I want information from "Employee" but instead only receive #NAME? Please any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
| IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE") | Excel Programming | |||
Linear Mode
