Hi,
I am getting really confused using the match address and indirect statements in a formulae.
I have attached an excel example of what I am trying to achieve and I'm hoping someone can assist.
I have two worksheets EUC and DV:
Worksheet EUC contains a column of asset numbers (column 1)
Worksheets DV contains a range of assets held by a person. The person's name is column A and the asset numbers are in columns B, C, D, E, F.
What I am trying to do is beside each of the Asset Numbers in EUC place the name that corresponds to that number from sheet DV Column 1,
In the DV asset register there is a total of 4 assets that a person can hold.
If they don't hold the asset then the cell is blank otherwise it has a number in it.
I have tried using the MATCH function but am getting an error.
The Row 1 show the headers of what I am trying to get.
I want to use this as a learning example.
If anyone can help I would greatly appreciate this as currently I have to do each asset number manually using copy and find. There is a lot of assets.
Cheers Tony
Bookmarks