This is a tricky one

[gymbag]

Sure, here's what I'm looking at, although I'm not sure exactly how this
will turn up on the post:

Item # Style Size Colour
C001 V-neck Large White on Black

Current in-stock quantity: 5
PSO teams quantity: 0


Item # Style Size Colour
C002

Current in-stock quantity: 0
PSO teams quantity: 0


Item # Style Size Colour
C003

Current in-stock quantity: 0
PSO teams quantity: 0

The item # is the only value that changes between these tables. I'm
hoping to automatically update the "Current in-stock quantity" on
another sheet for each item. However, the location of this cell is
causing problems because it shares neither a row or column with the
reference cell (ie A25 vs D28). I'm still trying to somehow incorporate
OFFSET (ie lookup C001 and report the cell 3 over and 2 down), but I'm
not having much luck.

Thanks Frank!

 

[Dave Peterson]

maybe if your item number is in A2 and your value to be brought back is always
two rows under the matching item number on sheet2 in column D. (I got lost on
what was where.)

=index(sheet2!d:d,match(a2,sheet2!a:a,0)+2)

(essentially, find the match, come down two rows. But take it from column D.)