CODEWITHSUNDEEP
if-statementgoogle-sheetsconcatenationarray-formulasgs-vlookup
youg3
youg3

Reputation: 1

Vlookup then return a different row in Google Sheets

I'm struggling to figure out how to get sheets to first look up the location of a key value and then look up which of the sub values it should take. Best would be to include an example, which:

https://docs.google.com/spreadsheets/d/1pL62W7pSImMlTdnU3RMV4VDK3KIuNBT8l3VxClLGTd4/edit?usp=sharing

What I'm hoping to achieve is that the values for item 1, when selected, auto fill in the correct gear builder fields.

Any advice on this is hugely appreciated.

Upvotes: 0

Views: 85

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(
 IF(F4:F12<>"", VLOOKUP(ROW(A4:A12), 
 IF(G4:G12<>"", {ROW(A4:A12), G4:G12&"♦"}), 2, 1), )&F4:F12, {
 IF(B4:B12<>"", VLOOKUP(ROW(A4:A12), 
 IF(A4:A12<>"", {ROW(A4:A12), A4:A12&"♦"}), 2, 1), )&B4:B12, C4:C12}, 2, 0)))

0

Upvotes: 1

Related Questions