How can I use "VLOOKUP" with different Table Arrays

[gnarvaez3]

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?

 

[Rachel Garrett]

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