Finding data in a unknown cell

  • Thread starter Thread starter DMSPaul
  • Start date Start date
D

DMSPaul

Hi, hope someone can help.

I have a spreadsheet which has items and their respective quantitys in
2 simple columns.
The item names are consistent and do not change, however the items and
their position within the spreadsheet changes everyday as it is taken
from an external source.
I can find whether ITEMx exists easy enough with the COUNTIF function*,
however since it's position will change everyday I can't put in a
static formula of it's quantity since I won't know the cell it's in (I
don't want to do it manually).
Basically is there a function to display a cell to the right (or any
direction) of a certain cell.

*is there a better way of doing this, that might solve my problem?


Thanks for any help anyone can give.

Paul
 
DMSPaul said:
Hi, hope someone can help.

I have a spreadsheet which has items and their respective quantitys in
2 simple columns.
The item names are consistent and do not change, however the items and
their position within the spreadsheet changes everyday as it is taken
from an external source.
I can find whether ITEMx exists easy enough with the COUNTIF function*,
however since it's position will change everyday I can't put in a
static formula of it's quantity since I won't know the cell it's in (I
don't want to do it manually).
Basically is there a function to display a cell to the right (or any
direction) of a certain cell.

*is there a better way of doing this, that might solve my problem?


Thanks for any help anyone can give.

Paul
Click to expand...

As an example, this formula will look up the contents of C1 in the range
A1:A10 and return the corresponding value from B1:B10, or #N/A if it is not
found:
=VLOOKUP(C1,A1:B10,2,0)
 
Back
Top