GoogleSheet - Trying to use nested MATCH inside VLOOKUP

[jonathan92591]

Hi All - I am trying to use "Match" inside a "Vlookup" for the Index input on the "Vlookup" formula. I am trying to pull "Estimated Hours" from one spreadsheet to another spreadsheet using "Work Order ID" as the ID>

Work Order Log to Work Order Log - Rollup

Spreadsheets: https://drive.google.com/open?id=1kFYjRcMAKDx5eJHYdQAqFnyVs6m8O1pu

Attempt without nested "Match":

=VLOOKUP($A2,IMPORTRANGE("1c-Mu40dSREGNUeuY5DjIftspdT9QG8O5zf4q1W2QxC4","Details!A2:P502"),14,0)

Attempt WITH nested "Match":

=VLOOKUP($A3,IMPORTRANGE("1c-Mu40dSREGNUeuY5DjIftspdT9QG8O5zf4q1W2QxC4","Details!A2:P502"),MATCH("ESTIMATED HOURS",IMPORTRANGE("1c-Mu40dSREGNUeuY5DjIftspdT9QG8O5zf4q1W2QxC4","Details!A1:A50"),0),0)

Thank you for your support in advance. - JT

 

[jonathan92591]

Correction to formulas:

Attempt without nested "Match": Does Work

=VLOOKUP($A2,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A2:B7"),2,0)

Attempt WITH nested "Match": Doesn't Work

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A2:P502"),MATCH("ESTIMATED HOURS",IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A1:A50"),0),0)

 

[jonathan92591]

My friend solved it! The formula was:

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A2:B7"),MATCH("Estimated Hours",IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!1:1"),0),0)

I was the last part of the match, I was typing A but it was 1.

Thank you all!

 

[Aladin Akyurek]

See if one of the following would work?

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A:P"),MATCH("ESTIMATED HOURS",IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A1:P1"),0),0)

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A2:P502"),MATCH("ESTIMATED HOURS",INDEX(IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A:P"),1,0),0),0)

 

[jonathan92591]

See if one of the following would work?

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A:P"),MATCH("ESTIMATED HOURS",IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A1:P1"),0),0)

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A2:P502"),MATCH("ESTIMATED HOURS",INDEX(IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A:P"),1,0),0),0)

Details!A:P change the A and the P to 1

So Details!1:1"

That ended up working out for us.

 

[Aladin Akyurek]

Details!A:P change the A and the P to 1

So Details!1:1"

That ended up working out for us.

So you did not check out the suggestions.

 

[jonathan92591]

So you did not check out the suggestions.

Ok. I tried the two you suggested. They did not work.

This ended up working:

=VLOOKUP($A3,IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!A2:B7"),MATCH("Estimated Hours",IMPORTRANGE("1TVAEdKxfPjIqjPDXqEpRVLoqDQZJP9658g4iwNSfzD8","Details!1:1"),0),0)

 

[Aladin Akyurek]

They should work, but never mind.

You have a solution. Try to add a column in front of the current column of the data range. Does the solution you opted for still work?