Need to lookup with multiple criteria and not duplicate results

[forginganewone]

[FONT=&quot]Example File link :https://a.uguu.se/VShSGr3aIRRg_Example.xlsx[/FONT]
[FONT=&quot]I need to use vlookup with 2 criteria and 3 conditions.[/FONT]
[FONT=&quot]Criteria:
Cell A2 : *AC*
Cell B2 : Location Code for ex: 3324
Lookup A2 in clolumn B of sheet2
Lookup B2 in column F of sheet3[/FONT]
[FONT=&quot]I will use this to get 4 values : 1) Asset Code, 2) Current Cost, 3) DEP, 4) NBV[/FONT]
[FONT=&quot]Conditions :
1) Provide the lowest available NBV first
2) If Asset Code already present then provide next available asset code
3) If description not available in provided location(B2) then pick from any location.[/FONT]

 

[Chrisdontm]

Your link doesn't work...

 

[forginganewone]

Your link doesn't work...

https://a.uguu.se/N4Z2IlGET4QX_Example.xlsx

 

[Chrisdontm]

I believe this is most of what you are asking for...The areas shaded in gray.

Take a look at it and let me know what else you are wanting...

The "array" formulas I made are working off of the information in the "LOCATION" column.


https://www.dropbox.com/s/xtbrirzhqe9yrjm/Copy-1 N4Z2IlGET4QX_Example.xlsx?dl=0

[ FYI; If you go into the formulas, then you must use Ctrl + Shift + Enter to activate them...]