VOOKUP previous column from different sheet

[lecet444]

=VLOOKUP(D1,'F:\Engineering\Michael\Excel\INVENTORY\PO\[7419.xls]PO'!$D$16:$Q$16,2,0)

I would love to make that a -1

there is noway of me changing the colums on those sheets (there are hundreds + the master one is setup that way. qty before part #.

anyway around this

 

[Jonmo1]

Yep, it's called the Zoolander effect..
Vlookup can only Look to the right, it can't look left...

This is one of the reasons Index/Match is MUCH better than Vlookup...


Try

=INDEX('F:\Engineering\Michael\Excel\INVENTORY\PO\[7419.xls]PO'!$C$16:$C$16,MATCH(D1,'F:\Engineering\Michael\Excel\INVENTORY\PO\[7419.xls]PO'!$D$16:$D$16,0))

Returns a value from column C, based on the match in column D.


Hope that helps...


Note, although it appears you're only looking in 1 ROW of data D16:O16, kinda defeats the purpose of VLOOKUP...
Unless that was just a quick example, and it's actually something like D16:O1000

 

[lecet444]

like a charm
thank you very much

 

[lecet444]

my next bit is how to incorporate that in a code, where every row is different PO (each po is a differnt file name)
but the the PO number is on the row