PC Review


Reply
Thread Tools Rate Thread

How can I use "VLOOKUP" with different Table Arrays

 
 
gnarvaez3
Guest
Posts: n/a
 
      19th Jun 2008
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 With Quote
 
 
 
 
Rachel Garrett
Guest
Posts: n/a
 
      19th Jun 2008
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 <gnarva...@discussions.microsoft.com>
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
correct syntax for nesting "if", "and", and "vlookup"....if possib Christine Microsoft Excel Worksheet Functions 4 2nd Jan 2009 10:43 PM
How to replace "#N/A" w "0"when vlookup couldn't find the match? =?Utf-8?B?SG9sbHk=?= Microsoft Excel Misc 2 17th Jul 2006 11:48 PM
How do I make the "Show Table" and "Linked Table" windows bigger? =?Utf-8?B?UmlvRGVTbW9rZQ==?= Microsoft Access 3 1st Nov 2005 03:37 PM
IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE") =?Utf-8?B?U291cmlz?= Microsoft Excel Programming 2 17th Aug 2005 05:33 AM
Problem with "On error resume next" with "custom VLookup" =?Utf-8?B?RmFjdGl2YXRvcg==?= Microsoft Excel Programming 4 21st Jul 2004 02:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:24 PM.